MySQL: how to select everything except the first 10 records

Question

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

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

Answer 1

Use OFFSET . Then you can skip 10 entries and select the rest to the end.

Then your request should look like

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

Answer 2

It’s better to get used to LIMIT because you can use it also for pagination.