比如 select e_name,id,path from game where id in(1,3,7,11,25,24,16,10,8) order by FIND_IN_SET(id,'1,3,7,11,25,24,16,10,8')