select in order by

为什么80%的码农都做不了架构师？>>>   

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);

转载于:https://my.oschina.net/nealma/blog/129568