Mysql in 排序

SELECT `id` FROM `topic` WHERE `id` IN ('444','512','447','509','504','445','511') ORDER BY FIELD(id,444,512,447,509,504,445,511)


SELECT `id` FROM `topic` WHERE `id` IN ('444','512','447','509','504','445','511') ORDER BY INSTR('444,512,447,509,504,445,511,', CONCAT(id,','))

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/zhaoyuqi/p/6722565.html