MySQL - SELECT ... WHERE id IN (..) - correct order

Question

I have the following query

SELECT * FROM table WHERE id IN (5,4,3,1,6)

and i want to retrieve the elements in the order specified in the "id in.." meaning it should return:

5 ....
4 ....
3 ....
1 ....
6 ....

Any ideas how to do that?

question from:https://stackoverflow.com/questions/5090591/mysql-select-where-id-in-correct-order

Answer 1

Use FIELD():

SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6);