SELECT * FROM `t_task_info` ORDER BY IF(ISNULL(end_at),0,1) ,end_at ASC
mysql 按时间降序排序、时间为空的排在前面
最新推荐文章于 2023-10-16 13:41:30 发布
SELECT * FROM `t_task_info` ORDER BY IF(ISNULL(end_at),0,1) ,end_at ASC