sql query returns error when using limit
why does this query work? how am i supposed to write it?
select * from tbl_content order by year desc where visible = '1' limit 0,3开发者_如何学Go0;
WHERE Clauses come before ORDER BY.
Rewrite as:
select * from tbl_content where visible = '1' order by year desc limit 0,30;
精彩评论