实现按 2,1,3排序:
SELECT * FROM user where id in (1,2,3) ORDER BY locate(id,'2,1,3') ;
SELECT * FROM user ORDER BY field(id,2,1,3) desc
SELECT * FROM user where id in (1,2,3) ORDER BY INSTR('2,1,3',id)
实现按 2,1,3排序:
SELECT * FROM user where id in (1,2,3) ORDER BY locate(id,'2,1,3') ;
SELECT * FROM user ORDER BY field(id,2,1,3) desc
SELECT * FROM user where id in (1,2,3) ORDER BY INSTR('2,1,3',id)