php - Mysql WHERE IN 函数中的 Order by 问题

Question

SELECT * FROM (`poll`) WHERE `poll_id` IN ('6,10,5,9,1') AND `poll_status` = '1'

我尝试了这个查询。我期望它会给出我给出的结果。但它会自动按升序对结果进行排序。我需要付出的结果。请给我一个解决方案。提前致谢。

Answer 1

您可以在mysql中使用FIELD:

SELECT * 
FROM (`poll`) 
WHERE `poll_id` IN (6,10,5,9,1) 
  AND `poll_status` = 1
ORDER BY FIELD(`poll_id`,6,10,5,9,1)