排序时将某列中特定值排在最前,例如我在排序中要把year=2012 放在最前面:
select * from sales order by year desc
select * from sales order by if(year='2012',0,1), year desc
排序时将某列中特定值排在最前,例如我在排序中要把year=2012 放在最前面:
select * from sales order by year desc
select * from sales order by if(year='2012',0,1), year desc