order by 自定义排序的方法

一、order by case

目标排序：香蕉>苹果>橘子

select type,sales
from T
order by CASE when type = '香蕉' then '1'
              when type = '苹果' then '2'
              when type = '橘子' then '3'
              else null END 

二、order by field

目标排序：1>3>2>4

select * from ts_staff_transfer_log 
order by field(transfer_type,1,3,2,4)