csdn

mysql ordery by if语句查询

假设表_table有4个字段 select * from _table as t order by if(t.id='1',3,1) desc这样的查询结果和 select * from _table as t order by if(t.id='1',3,10 ...