MySQL Select WHERE IN given order

Question

I have something like:

SELECT * FROM table WHERE id IN (118, 17, 113, 23, 72); 

It returns the rows ordered by ID, ascending. Is there a way to get back the rows in the order specified in the IN clause?

Answer 1

You should use "ORDER BY FIELD". So, for instance:

SELECT * FROM table WHERE id IN (118,17,113,23,72)  ORDER BY FIELD(id,118,17,113,23,72) 

Answer 2

Try using FIND_IN_SET:

SELECT * FROM table WHERE id IN (118,17,113,23,72)      ORDER BY FIND_IN_SET(id, '118,17,113,23,72');