Is there a way in MySQL to have the first 10 result from a SELECT query skipped? I'd like it to work something like LIMIT.
This question is related to
mysql
If your table has ordering by id, you could easily done by:
select * from table where id > 10
There is an OFFSET as well that should do the trick:
SELECT column FROM table
LIMIT 10 OFFSET 10
Use LIMIT with two parameters. For example, to return results 11-60 (where result 1 is the first row), use:
SELECT * FROM foo LIMIT 10, 50
For a solution to return all results, see Thomas' answer.
From the manual:
To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:
SELECT * FROM tbl LIMIT 95,18446744073709551615;
Obviously, you should replace 95
by 10
. The large number they use is 2^64 - 1, by the way.
select * from table where id not in (select id from table limit 10)
where id
be the key in your table.
OFFSET is what you are looking for.
SELECT * FROM table LIMIT 10 OFFSET 10
LIMIT allow you to skip any number of rows. It has two parameters, and first of them - how many rows to skip
Source: Stackoverflow.com