Yes there is.. You can use LIMIT keyword to do so. For example to get the records between 3 and 5, you could issue the statement:
SELECT * FROM content ORDER BY id LIMIT 2, 3; See: http://www.mysql.com/doc/S/E/SELECT.html Gurhan -----Original Message----- From: lance turner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 5:08 PM To: [EMAIL PROTECTED] Subject: skipping rows after select After executing a query such as: SELECT * FROM content ORDER BY id I there a SQL query for skipping ahead a certain number of records? Or should this be done as part of the initial query? If so, how? thanks, lance turner --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php