工作笔记, 仅供参考
select uid, name from table_user_name order by field(
uid
, 8,1,4,6,3) desc
注:先8,1,4,6,3倒叙排列, 其他的再排序。
select uid, name from table_user_name order by field(uid
, 8,1,4,6,3)
注: 其他的排在最前面,接着是按8,1,4,6,3顺序排序。
select uid, name from table_user_name where uid in (8,1,4,5,3) order by field(uid
, 8,1,4,5,3) desc