查询语句:
select id,name,stauts from special where id in (50,51,52,53,54,55) order by FIELD( id ,51,50, 54,53,52,55)
查询结果是:
查询语句会依据Field 后面的顺序去排序