普通的按某一个字段或者多个字段排序没办法满足我们的需求时,可以通过case when来排序
mysql> select * from test order by field(num,-1) desc;
mysql> select * from test order by case when num = -1 then 1 else 0 end desc;
普通的按某一个字段或者多个字段排序没办法满足我们的需求时,可以通过case when来排序
mysql> select * from test order by field(num,-1) desc;
mysql> select * from test order by case when num = -1 then 1 else 0 end desc;
转载于:https://my.oschina.net/u/947065/blog/897711