MySQL offset infinite rows

Question

I would like to construct a query that displays all the results in a table but is offset by 5 from the start of the table. As far as I can tell, MySQL's LIMIT requires a limit as well as an offset. Is there any way to do this?

Answer 1

To retrieve all the rows from a certain offset up to the end of the result set, you need to use some large number for the second parameter. 

The below statement can retrieve all the rows from the 96th row to the last:

Query:

SELECT * FROM tbl LIMIT 95, 18446744073709551615;

For detailed information, refer to this MySQL Manual on LIMIT