假若有给定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')