你可以试着用 case when 中的表达式 order by 条款

select * from tablename
order by case when key='F' then 1 when key='W' then 2 when key='H' then 3 end

试试这个：

select * from table1 where key in ('F','W','H')
order by case
when key ='F' then 1
when key ='W' then 2
else 3
end;

使用解码

select a.* from yourtablename a
order by decode(Key,'F',1,'W',2,'H',3)

或

order by instr('FWH',Key)