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 ?