mysql when then 用法

select  case id  when 5 then 1

                           when 10 then 2

                           when 4 then 3

                          end as row ,id from 表明 where （ID =7 ）or （ID=8）or （ID=2）order by row;

select * from table where (id in(10,32,22)) order by find_in_set(id,'10,32,22');