sql select的时候按特定的顺序排序 select * from A order by case Name when 'wind' then 1 When 's' then 2 when 't' then 3 end ASC就是在Order by 后面加个case when