您的位置: 首页 > IT文章 > mysql 排序 mysql 排序 分类: IT文章 • 2024-01-23 18:39:19 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')