1.根据内部函数
SELECT adplace_id FROM mj_adplace_manage WHERE service={$service} AND adplace_id in (".$data.") order by find_in_set(adplace_id,'".$data."')
2.这个方法也可以
select id from table where id in (2,1,3,5) order by substring_index('2,1,3,5',id,1);