Home  >  Article  >  Backend Development  >  mysql 查询有关问题

mysql 查询有关问题

WBOY
WBOYOriginal
2016-06-13 11:42:59701browse

mysql 查询问题
select * from commodity WHERE name LIKE $keywords ORDER BY rank $rank limit $pages, $rows


WHERE、ORDER、limit这三个同时用应该怎么排啊,上面这句不行 


这样就可以 select * from commodity ORDER BY rank $rank limit $pages, $rows

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn