select
a.*
from table a
ORDER BY
FIND_IN_SET(a.name,'zhaoqian,sunli,zhouwu,zhengwang');
-- 查询结果,会按照名称分别是 zhaoqian sunli zhouwu zhengwang 的顺序排序
select
a.*
from table a
ORDER BY
FIND_IN_SET(a.name,'zhaoqian,sunli,zhouwu,zhengwang');
-- 查询结果,会按照名称分别是 zhaoqian sunli zhouwu zhengwang 的顺序排序