select a range of values in mysql

Question

How would I select all but the first 3 rows in my MySql query?

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

Well i'd like it to be work regardless of how I ordered or sorted it. — ian, Jul 07 '10 at 05:38
possible duplicate of [Mysql Offset Infinite rows](http://stackoverflow.com/questions/255517/mysql-offset-infinite-rows) — Felix Kling, Jul 07 '10 at 05:40

score 2 · Answer 1 · answered Jul 07 '10 at 05:35

Do you want the following:

$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
    }
}

score 2 · Accepted Answer · edited May 23 '17 at 12:11

2

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

See this post for more info

edited May 23 '17 at 12:11

Community

1
1

answered Jul 07 '10 at 05:39

Amarghosh

58,710
11
92
121

score 0 · Answer 3 · answered Jul 07 '10 at 05:42

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

To find third record order by columnName use

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

To find All other than 1st 3 rows use LIMIT 2, total_no_of_rows

if you don't know total_no_of_rows use very large number instead of it.

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

This is all but the first *2*. – Matthew Flaschen Jul 07 '10 at 05:53 — Matthew Flaschen, Jul 07 '10 at 05:53

select a range of values in mysql

3 Answers3