问SQL搜索结果按搜索内容的顺序排列

EN

select t.*
from (select 9 as c, 1 as priority union all select 1, 2 union all select 8, 3
     ) vals left join
     table t
     on t.column = vals.c
order by vals.priority;

select t.*
from table t
where t.column in (9, 1, 8)
order by (case column when 9 then 1 when 1 then 2 when 8 then 3 end);

select *
from table_name
where column_name in (9,1,8)
order by case column_name 
                 when 9 then 1 
                 when 1 then 2 
                 when 8 then 3 end
         , column_name -- optional, but here could go another column if you want to have custom order

SELECT Column_name
FROM user_tab_columns
where table_name = 'MY_TABLE'
and Column_id in (9,1,8)