目录
1、原始表截图
2、需求:指定name1字段内某两条数据排序后放在最后
3、使用order by 与field组合
SELECT * from test order by field(name1,'cilly','qutty')
4、使用order by 与in组合
SELECT * from test order by name1 in ('cilly','qutty')
输出:
目录
SELECT * from test order by field(name1,'cilly','qutty')
SELECT * from test order by name1 in ('cilly','qutty')
输出: