用下面的语句

select * from ibs6_terminal_adv_inf where id in (16,14,15) order by field(id,16,14,15)

select * from ibs6_terminal_adv_inf where id in (16,14,15) order by find_in_set(id,'16,14,15')

select * from ibs6_terminal_adv_inf where id in (16,14,15) order by substring_index('16,14,15',id,1)

结果就是按顺序显示了

sqlserver 用以下的语句

select * from ibs6_terminal_adv_inf where id in (16,14,15)  order by CHARINDEX(','+ltrim(id)+',',',16,14,15,')"

另外还有下面这种case函数方式的

select   id   from   table1   where   id   in(3224,3225,3395,2810,3280,3281,3292) 

order   by  case   id  when   3224   then   1  when   3225   then   2  when   3395   then   3  when   2810   then   4  when   3280   then   5  when   3281   then   6  when   3292   then   7  end