MySQL根据某个字段值进行排序

使用case when语句

SELECT id,name FROM user ORDER BY CASE WEHN id = '1' TEHN 1 WHEN id = '2' THEN 2 ELSE 3 END ;