MySQL根据字段值排序（非直接排序）

MySQL根据某个字段取值的特定顺序来进行排序

1、SELECT * from iot_app 
order by (CASE
        WHEN `status` = 2  THEN 0
        WHEN `status` = 1 THEN 1
        WHEN `status` = 3  THEN 2
        WHEN `status` = 4 THEN 3
        ELSE 4 END) asc ;

2、SELECT * from iot_app 
order by FIELD(status,'2','1','3','4') ;