mysql 指定某个字段的值排序

案例:

select
    *
from
    f_xxx fb
order by
    (case
        when fb.status = 0 then 1
        when fb.status = 3 then 2
        when fb.status = 1 then 3
        when fb.status = 2 then 4
        else 4
    end)