eg:
SELECT * FROM student WHERE name LIKE '%张三%'
ORDER BY (
CASE
WHEN name='张三' THEN 1
WHEN name like '张三%' THEN 2
WHEN name like '%张三%' THEN 3
WHEN name like '%张三' THEN 4
ELSE 5
END
)
eg:
SELECT * FROM student WHERE name LIKE '%张三%'
ORDER BY (
CASE
WHEN name='张三' THEN 1
WHEN name like '张三%' THEN 2
WHEN name like '%张三%' THEN 3
WHEN name like '%张三' THEN 4
ELSE 5
END
)