Order by 时能否使用case when

[Ambition9186]

想要排序时根据一组值置顶: SELECT * FROM user ORDER BY CASE WHEN id IN (13349, 13348, 13347,13346,13345,13344,13343,13342,13341) THEN 0 ELSE 1 END,id;

[silver-brother]

可以自己实现