MySQL skip first 10 results

Question

Is there a way in MySQL to have the first 10 result from a SELECT query skipped  I d like it to work something like LIMIT

User · Answer

OFFSET is what you are looking for   SELECT   FROM table LIMIT 10 OFFSET 10

User · Answer

LIMIT allow you to skip any number of rows  It has two parameters  and first of them - how many rows to skip

User · Answer

If your table has ordering by id  you could easily done by   select   from table where id  gt  10

User · Answer

select   from table where id not in  select id from table limit 10    where id be the key in your table

User · Answer

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

User · Answer

There is an OFFSET as well that should do the trick   SELECT column FROM table LIMIT 10 OFFSET 10

User · Answer

From the manual      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     Obviously  you should replace 95 by 10  The large number they use is 2 64 - 1  by the way

[mysql] MySQL skip first 10 results

Examples related to mysql