1.order by 按制定值排序
SELECT * FROM USER ORDER BY LOCATE(id,'2,3,1,5,4,6,7,8,9,10,11,12,13,14,15');
2.where in 排序
Select * FROM table1 Where (ID IN (3,5,1,4,2)) ORDER BY FIND_IN_SET(ID, '3,5,1,4,2')1.order by 按制定值排序
SELECT * FROM USER ORDER BY LOCATE(id,'2,3,1,5,4,6,7,8,9,10,11,12,13,14,15');
2.where in 排序
Select * FROM table1 Where (ID IN (3,5,1,4,2)) ORDER BY FIND_IN_SET(ID, '3,5,1,4,2')