MySQL 下不规则排序

2014-11-24 18:12:09 · 作者: · 浏览: 0

SQL查询语句如下:


select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44)


让结果按10,32,22,76,13,44的顺序检索出来,请问如何书写? (sql能力)


select * from table where (ID = 10) or (ID = 32) or (ID = 22) or (ID = 76) or (ID = 13) or (ID = 44) order by field(ID,10,32,22,76,13,44)