SELECT * FROM `t_task_info` ORDER BY IF(ISNULL(end_at),0,1) ,end_at ASC
mysql 按时间降序排序、时间为空的排在前面
最新推荐文章于 2024-05-15 09:28:09 发布
SELECT * FROM `t_task_info` ORDER BY IF(ISNULL(end_at),0,1) ,end_at ASC