SQL SELECT跳过前N个结果? [英] SQL SELECT skip first N results?

问题描述

这是我的查询:

    $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屋！