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.
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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With