SELECT * FROM t_role ORDER BY case
WHEN role_name like '%管理员%' then 4
WHEN role_name like '%经办员%' then 2
WHEN role_name like '%复核员%' then 3
end
asc
WHEN role_name like '%管理员%' then 4
WHEN role_name like '%经办员%' then 2
WHEN role_name like '%复核员%' then 3
end
asc