MySQL: how to select everything except first 10 records

Question

How can I select all records except first 10 records from MySQL table?

(I know that limit 10,x selects records from the 10th to x-th, but what should I use instead of x to select all remaining records?)

Duplicate of http://stackoverflow.com/questions/255517/mysql-offset-infinite-rows ? — Graham, Jun 02 '13 at 17:25
Or duplicate of http://stackoverflow.com/questions/5619167/mysql-limit-offset-get-all-records-except-the-first-x?lq=1 ? — Tomas Prado, Jun 02 '13 at 17:27

Lucia Pasarin · Answer 1 · 2013-06-02T17:46:22.913

6

Use OFFSET. Then you can skip 10 records and select the remaining ones until the end.

Then your query should look like

SELECT field FROM table WHERE (condition) LIMIT 18446744073709551615 OFFSET 10;

edited Jun 02 '13 at 17:46

answered Jun 02 '13 at 17:26

Lucia Pasarin

`OFFSET` is not a valid MySQL clause. – Graham Jun 02 '13 at 17:38
1

`OFFSET` *is* a valid mysql clause. The problem is that it must be after the `LIMIT` clause or it won't work. Check the docs : http://dev.mysql.com/doc/refman/5.0/en/select.html – Tomas Prado Jun 02 '13 at 17:40
1

@Tomas, yes it's valid as part of a `LIMIT`, but not on its own as the above answer was implying. – Graham Jun 02 '13 at 17:41
Edited. 18446744073709551615 is the number that I found is used in the documentation to get records until the last one. – Lucia Pasarin Jun 02 '13 at 17:48
3

Also, the same query can be done like this `LIMIT 10, 18446744073709551615` – Tomas Prado Jun 02 '13 at 17:51

score 0 · Answer 2 · answered Jun 02 '13 at 17:37

0

Better get used to LIMIT condition because you can use it also for pagination.

answered Jun 02 '13 at 17:37

2 Answers2