来试试看
SELECT
* form TABLE
WHERE
id LIKE '%x%'
OR id LIKE '%y%'
ORDER BY
(
(
CASE
WHEN id LIKE '%x%' THEN
2
ELSE
0
END
) + (
CASE
WHEN id LIKE '%y%' THEN
1
ELSE
0
END
)
) ASC;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024