mysql按id的指定顺序进行排序,以前解决过一次,后来忘了,记录一下 SELECT * FROM `table` WHERE id<6 order by field(id,3,5,1,2,4) 转载于:https://www.cnblogs.com/cutchaos/p/9520203.html