一道mysql面试题

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的顺序检索出来,请问如何书写？

SELECT *
FROM `table`
WHERE id =10
UNION
SELECT *
FROM `test`
WHERE id =32
UNION
SELECT *
FROM `test`
WHERE id =22

...

转载于:https://blog.51cto.com/hjun169/803861