MySQL skip first 10 results

by

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.

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. Left Outer Join doesn’t return all rows from my left table?
  3. Are table names in MySQL case sensitive?
  4. MySQL: is a SELECT statement case sensitive?
  5. Check overlap of date ranges in MySQL
  6. 1114 (HY000): The table is full
  7. Get table names using SELECT statement in MySQL
  8. UPDATE multiple tables in MySQL using LEFT JOIN
  9. Can a foreign key reference a non-unique index?
  10. How to raise an error within a MySQL function
  11. What is maximum query size for mysql?
  12. Storing Data in MySQL as JSON
  13. Finding all parents in mysql table with single query (Recursive Query)
  14. setting global sql_mode in mysql
  15. Compare dates in MySQL
  16. MySQL root password change
  17. MySQL join query using like?
  18. MySQL: update a field only if condition is met
  19. MySql Query: Select top 3 rows from table for each category
  20. MySQL: How to select records for this week?
  21. Split a string and loop through values in MySQL stored procedure
  22. MySQL Select Query – Get only first 10 characters of a value
  23. Create an index on a huge MySQL production table without table locking
  24. MySQL concurrency, how does it work and do I need to handle it in my application
  25. mysql select id and name from other table and join query
  26. How to import large sql file in phpmyadmin
  27. How to figure out size of Indexes in MySQL
  28. Equivalent of MSSQL IDENTITY Column in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment