MySQL skip first 10 results

mysql

Use LIMIT with two parameters. For example, to return results 11-60 (where result 1 is the first row), use:

SELECT * FROM foo LIMIT 10, 50

For a solution to return all results, see Thomas' answer.

mysql

There is an OFFSET as well that should do the trick:

SELECT column FROM tableLIMIT 10 OFFSET 10

mysql

OFFSET is what you are looking for.

SELECT * FROM table LIMIT 10 OFFSET 10

CodeHunter