LINUX.ORG.RU

История изменений

Исправление NeOlip, (текущая версия) :

SELECT `id`, `name`, `birthday`
FROM `user`
WHERE DAYOFYEAR(`birthday`) > DAYOFYEAR(CURDATE())
ORDER BY (ABS(DAYOFYEAR(CURDATE()) - DAYOFYEAR(`birthday`)));

Исходная версия NeOlip, :

SELECT `id`, `name`, `birthday` FROM `user` WHERE DAYOFYEAR(`birthday`) > DAYOFYEAR(CURDATE()) ORDER BY (ABS(DAYOFYEAR(CURDATE()) - DAYOFYEAR(`birthday`)));