Почему не выполняется MYSQL запрос?

Question

[entermix]

SELECT `id`, `created`, DATEDIFF(CURDATE(), FROM_UNIXTIME(`created`)) AS `date_diff` FROM `users` WHERE `date_diff` = 5

#1054 - Unknown column 'date_diff' in 'where clause'

Почему?

Answer 1

[AlexeyVD]

Такое условие нужно выносить в HAVING.

SELECT `id`, 
       `created`, 
        DATEDIFF(CURDATE(), FROM_UNIXTIME(`created`)) AS `date_diff` 
FROM `users` 
HAVING`date_diff` = 5