order by按照指定記錄排序

//按照id降序 並把name是小黑的排在最後
SELECT * from dms_student order by name not like '小黑' desc,id desc;

//按照id降序 並把name是小黑的排在最前面 去掉desc即可
SELECT * from dms_student order by name not like '小黑' ,id desc;