MySQL order by IN array

Question

I have a MySQL script like this: SELECT id, name FROM users WHERE id IN (6,4,34)

The sequence in the IN(...) array is very important. Is it possible to get them in the given sequence?

Answer 1

You can use the MySQL FIELD function to keep it compact;

SELECT id, name 
FROM users 
WHERE id IN (6, 4, 34)
ORDER BY FIELD(id, 6, 4, 34);

Answer 2

Try

SELECT id, name FROM users WHERE id IN (6,4,34) order by FIELD(id,6,4,34)