在mysql中选择一个值范围

Question

如何选择MySql查询中除前3行以外的所有行？

$query = mysql_query("SELECT * FROM comments WHERE approved = 1");  

Answer 1

SELECT * FROM comments WHERE approved = 1 LIMIT 3,SOME_HUGE_NUMBER

See this post for more info

Answer 2

您是否需要以下内容：

$query = mysql_query("SELECT * FROM comments WHERE approved = 1");
$rowCount = 0;
while ($row = mysql_fetch_assoc($query)) {
    $rowCount = $rowCount + 1;
    // do stuff only if you have reached the third row.
    if ($rowCount > 3){
        // do stuff here
    }
}

Answer 3

$query = mysql_query("SELECT * FROM comments
                                     WHERE approved = 1 
                                     ORDER BY columnName 
                                     LIMIT 3");

要按columnName查找第三个记录顺序，请使用

$query = mysql_query("SELECT * FROM comments
                                     WHERE approved = 1 
                                     ORDER BY columnName 
                                     LIMIT 2, 1");

要查找前3行以外的所有行，请使用LIMIT 2, total_no_of_rows

如果您不知道total_no_of_rows，请使用非常大的数字来代替它。

$query = mysql_query("SELECT * FROM comments
                                     WHERE approved = 1 
                                     ORDER BY columnName 
                                     LIMIT 2, total_no_of_rows");