您应该使用“ ORDER BY FIELD”。因此,例如:
SELECT * FROM table WHERE id IN (118,17,113,23,72)
ORDER BY FIELD(id,118,17,113,23,72)
MySQL按给定顺序选择WHERE
您应该使用“ ORDER BY FIELD”。因此,例如:
SELECT * FROM table WHERE id IN (118,17,113,23,72)
ORDER BY FIELD(id,118,17,113,23,72)