I think you should use something like LIMIT 50, 15 Check the manual for the correct syntax. (http://www.mysql.com/doc/en/SELECT.html explains it better than me)
Thanks Emery ----- Original Message ----- From: "Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 17:49 Subject: LIMITS > > when I do a query is there a way to IGNORE the first X number of returned > records??? > > For instance I want to see 15 records after the first 50. > > > > > Shawn Cummings > Engineering Project Manager > Global NAPs > 10 Merrymount Rd > Quincy, MA 02169 > Desk 617-507-5150 > VoIP 617-507-3550 > [EMAIL PROTECTED] > > > > > > -- > 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]