I thought LIMIT limited you to N number of CONCURRENT record. ie. limit 10 or limit 20
I believe Ross would like to select select 1000 records and then do a
sub select of records 1-20 and then 21-40 on this record set
LIMIT also allows you to specify a starting record, i.e. LIMIT 50, 100 so Ross could change the first parameter to accomplish this.
Example:
First query: LIMIT 0, 20 Second: LIMIT 20, 20 Third: LIMIT 40, 20 etc....
Kevin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]