如只能item_id等于10的按指定字段排序 select * from t_stu order by (case when item_id=10 then `content_id` else 1 end) desc