mysql - 排序结果以匹配 WHERE IN 表达式中值的顺序

Question

有没有办法让 mysql 按照我在 WHERE 命令中询问的顺序从 Member 数据库返回结果？

SELECT * 
FROM Members 
WHERE MemberID = "6" 
OR MemberId="3" 
OR MemberID="5"

目前，无论我做什么，它都会返回按 MemberID ASC 排序的结果。我希望它在 6、3、5 之前返回，即按照我要求的顺序返回。

Answer 1

SELECT 
  * 
FROM 
  Members 
WHERE 
  MemberID IN ("6","3","5")
ORDER BY 
  FIELD(MemberID,"6","3","5");