select id,name from tbname where id in(3,4,1,5);
默认排序为:1,3,4,5
如果想要顺序仍为:3,4,1,5
两种方法
1,order by find_in_set
select id,name from tbname where id in(3,4,1,5) order by find_in_set(id,'3,4,1,5');
2,order by substring_index
select id,name from tbname where id in(3,4,1,5) order by substring_index('3,4,1,5',id,1);