按照 IN 条件传递的顺序获取 MySQL 记录

Question

希望结果与传递给 IN 条件的顺序相同:

SELECT * FROM `table_x` WHERE `id` IN (30, 12, 1001, 24);

获取:

id    | field_a | field_b--------------------------12    | ...     | ...24    | ...     | ...30    | ...     | ...1001  | ...     | ...

期待:

id    | field_a | field_b--------------------------30    | ...     | ...12    | ...     | ...1001  | ...     | ...24    | ...     | ...

Answer 1

SELECT * FROM `table_x` 
WHERE `id` IN (30, 12, 1001, 24) 
order by field(id, 30, 12, 1001, 24)