SELECT * FROM article where userid=4 order by sort asc LIMIT 0,10; 先根据写where 条件,再排序,在LIMIT. 转载于:https://www.cnblogs.com/TangGe520/p/9271877.html