在MySQL和PHP中按日期排序，并重视今天的日期

Question

I want to make an order by date to get the comments of user, but I want to give the importance to today date

if there's a comment today show it first and make the ordering with date for the rest.

I try to make this but always give me an error in syntax

SELECT *
FROM comment
ORDER BY IF(`DATE_TIME_COMMENT` = CURRENT_DATE())

is there any solution ?

Answer 1

First sort by a CASE returning "something lower", if date_time_comment is equal to current_date() and "something higher" else. Then, second, sort by date_time_comment.

SELECT *
       FROM comment
       ORDER BY CASE date_time_comment
                  WHEN current_date()
                    THEN 0
                  ELSE
                    1
                END,
                date_time_comment;

(Possibly add DESC after date_time_comment in the ORDER BY clause, if you want to have newest comments first.)