How to get a specified number of rows to be returned?

[Inandjo]

hi ,

i am writing a pager for an application, and i would like to know what SQL command i have to execute to have say row x to y in a result set.
Thanx

La faim justifie les moyens!

 

[hos2]

select * from table limit 10,100

return 100 rows from starting at row 10

(or was it the other way around??)

 

[sleipnir214]

hos2:
You have it right.


Inandjo:
The LIMIT clause, as hos2 has said, can return a number of rows, starting with a given position. But keep in mind that MySQL starts counting rows from 0.

So something like "LIMIT 10, 5" will return the 11th through 15th records. Think of the first number as being the number of records to skip.

Also, "LIMIT 0, 10" ("return 10 rows, skipping 0 rows" or "return the first 10 rows&quot can be abbreviated "LIMIT 10".

The LIMIT clause is documented as part of the SELECT query documentation:

http://www.mysql.com/doc/en/SELECT.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!