查询的时候要把某个字段的,特定值排在最前面:
* select * from a order by FIELD(class_nature_id,3,2,4) DESC
* select * from a order by class_nature_id in (183) desc ;
查询的时候要把某个字段的,特定值排在最后面:
select * from a order by FIELD(class_nature_id,3,2,4) asc
* select * from a order by class_nature_id in (183) asc;