方法一
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