mysql大于当前时间置顶升序，小于当前时间的置尾降序

select ec.id,classDate
from ea_curriculum ec
order by classDate < DATE_FORMAT(now(), '%Y-%m-%d'),if(classDate < now(),0,classDate),classDate desc