select ec.id,classDate
from ea_curriculum ec
order by classDate < DATE_FORMAT(now(), '%Y-%m-%d'),if(classDate < now(),0,classDate),classDate desc
mysql大于当前时间置顶升序,小于当前时间的置尾降序
发布时间 2023-03-22 22:13:33作者: 幸运刘
select ec.id,classDate
from ea_curriculum ec
order by classDate < DATE_FORMAT(now(), '%Y-%m-%d'),if(classDate < now(),0,classDate),classDate desc