CODEWITHSUNDEEP
mysqllimit
priktop
priktop

Reputation: 1155

MySQL LIMIT/OFFSET: get all records except the first X

I want to query all records from number 50 and up. So instead of doing something like LIMIT 49, 99999 I want to know if there is an official way.

Upvotes: 5

Views: 13535

Answers (1)

Konerak
Konerak

Reputation: 39763

No, sorry. From the MySQL Documentation:

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;

Upvotes: 14

Related Questions