1、指定字段值排序,在回复评论时需要把回复评论记录排在最前面进行回复; SELECT * FROM `comment_reply` WHERE `user_id` = xx ORDER BY field(reply_id,xx) DESC;