php - 使用限制时sql查询返回错误

Question

为什么这个查询有效？我该怎么写呢？

select * from tbl_content order by year desc where visible = '1' limit 0,30;

Answer 1

WHERE 子句出现在 ORDER BY 之前。

重写为:

select * from tbl_content where visible = '1'  order by year desc limit 0,30;