mysql 按指定顺序排序

方法一

SELECT * FROM test ORDER BY case when 字段名= '字段值' then 序号

SELECT * FROM test ORDER BY
case
when is_vip= 'vip' then 3
when is_vip= '否' then 2
when is_vip= 'vip+' then 1
end,
id DESC

方法二

SELECT * FROM test ORDER BY FIELD(字段名,'字段值1','字段值2'),id DESC
SELECT * FROM test ORDER BY FIELD(is_vip,'vip+','否','vip'),id DESC