MySQL 使用 WHERE `id` IN (...) 指定确切顺序

Question

有没有一种简单的方法可以通过 WHERE id IN (...) 子句分别对 MySQL 结果进行排序？示例:

SELECT * FROM articles WHERE articles.id IN (4, 2, 5, 9, 3)

返回

Article with id = 4
Article with id = 2
Article with id = 5
Article with id = 9
Article with id = 3

还有

SELECT * FROM articles WHERE articles.id IN (4, 2, 5, 9, 3) LIMIT 2,2

返回

Article with id = 5
Article with id = 9

更新:更具体地说，我想避免篡改 WHERE articles.id IN (4, 2, 5, 9, 3) 括号中的数据，因为这些 ID 是动态的并自动排序。

Answer 1

是的，有点:

SELECT * FROM articles
WHERE articles.id IN (4, 2, 5, 9, 3)
ORDER BY FIND_IN_SET(articles.id, '4,2,5,9,3')

但这是非标准 SQL，有点味道。