1.使用case when
ORDER BY CASE WHEN end_time>NOW() AND start_time < NOW() THEN 0 WHEN start_time > NOW() THEN 1 ELSE 2 END,ABS(TIMESTAMPDIFF(second,start_time,NOW()))
2.使用 if
ORDER BY IF(end_time>NOW(),0,1),ABS(TIMESTAMPDIFF(SECOND,start_time,NOW()))
1.使用case when
ORDER BY CASE WHEN end_time>NOW() AND start_time < NOW() THEN 0 WHEN start_time > NOW() THEN 1 ELSE 2 END,ABS(TIMESTAMPDIFF(second,start_time,NOW()))
2.使用 if
ORDER BY IF(end_time>NOW(),0,1),ABS(TIMESTAMPDIFF(SECOND,start_time,NOW()))