История изменений
Исправление 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`)));