SQL SELECT跳过前N个结果? [英] SQL SELECT skip first N results?
本文介绍了SQL SELECT跳过前N个结果?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是我的查询:
$result = mysql_query("SELECT * FROM Posts WHERE MATCH (City) AGAINST ('$city') ORDER by Date DESC LIMIT 10");
基本上,我想跳过前10个结果,而只选择结果N:$page * 10
,以显示与该页面相对应的结果.我该怎么办?
Basically I want to skip the first 10 results and only select result N: $page * 10
to show the results that correspond to that page. How can I do this?
推荐答案
您正在寻找OFFSET关键字
You're looking for the OFFSET keyword
$offset = $page*10;
$result = mysql_query("SELECT * FROM Posts WHERE MATCH (City) AGAINST ('$city') ORDER by Date DESC LIMIT 10 OFFSET '$offset'");
这篇关于SQL SELECT跳过前N个结果?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文