Wouldn't you just type SELECT.............LIMIT 10,10 ?? Mike Hillyer www.vbmysql.com
-----Original Message----- From: Anthony Ward [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 11:21 AM To: [EMAIL PROTECTED] Subject: Row Number Hi, If i have a table with just "Userid,Name,Language" where userid is primary key. now if i search the first 10 people that speaks english i.e SELECT * FROM tablex WHERE language='English' LIMIT 10; Can't i get the row number of the last matched record? So i can do SELECT...........LIMIT nex-ten-starting,10 Regards, Anthony W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
