Entry

is there any way to specify the rows that you want returned from a query - (ex. - get me rows # 31 - 45)

Jun 26th, 2001 05:16
Iain Bruce, Jeff Lynch, www.mysql.com

If you're using MySQL you can use:

select * from table LIMIT 5,10;

which would retrieve rows 6-15.

Hope this helps