SELECT * FROM demands ORDER BY IF(STATUS = 2, 2, 1),created_by DESC;
上述SQL执行结果:status=2的优先排在前面,然后按照created_by倒序排列
mysql某列等于固定值时优先排序
最新推荐文章于 2023-06-17 11:54:23 发布
SELECT * FROM demands ORDER BY IF(STATUS = 2, 2, 1),created_by DESC;
上述SQL执行结果:status=2的优先排在前面,然后按照created_by倒序排列