mysql - 如何按手动顺序取一些行，然后按常规方式休息

Question

我正在从数据库中获取国家/地区，并希望将其中一些手动添加到开头。该列表应如下所示:

Y <- those rows should be chosen by hand
X
R 
A <- and the rest is going to be in the regular order
B
C
D

Answer 1

您可以使用 case 表达式:

select t.*
from t
order by (case when col = 'Y' then 1
            when col = 'X' then 2
            when col = 'R' then 3
            else 4
       end),
      col;