Home > Article > Backend Development > mysql 查询有关问题
mysql 查询有关问题
- WBOYOriginal
- 2016-06-13 12:31:07978browse
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
Previous article： 下部这些代码能不能简写啊 Next article： 请教多条更新记录提交怎么写SQL