假若有给定id数组(1,9,3,5,6);查询sql语句需要安装这个顺序排序
select * from tb where id in (1,9,3,5,6) order by find_in_set(id,‘1,9,3,5,6‘)
mysql find_in_set排序
原文:http://www.cnblogs.com/yoursoul/p/6429382.html