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;