SELECT *
FROM mov_video_info
WHERE title LIKE '%魔兽%'
ORDER BY REPLACE(title,'魔兽','')
LIMIT 10
通过替换关键字为空字符串来改变排序规则。
SELECT *
FROM mov_video_info
WHERE title LIKE '%魔兽%'
ORDER BY REPLACE(title,'魔兽','')
LIMIT 10
通过替换关键字为空字符串来改变排序规则。