一、常用排序:
SELECT * FROM `test_table` ORDER BY `name` DESC;
二、指定关键字置顶排序:
SELECT * FROM `test_table` ORDER BY `name`='演示钩子' DESC;
三、指定关键字模糊置顶排序:
SELECT * FROM `test_table` ORDER BY `name` LIKE '模板%' DESC;
四、指定关键字顺序置顶排序:
SELECT * FROM `test_table` ORDER BY FIELD(`name`,'留言区','评论区','演示钩子') DESC;