The manual is your friend: http://dev.mysql.com/doc/mysql/en/SELECT.html
Pay attention to the portion about the LIMIT clause. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Randy Paries" <[EMAIL PROTECTED]> wrote on 09/07/2004 04:15:28 PM: > > Hello, > I have a table > Mytable:: > int ID > varchar Title > varchar description > > Mytable will have many records. In my queries (via web page) I want to > display 10 records at a time. > ID is an auto increment key. But there is a possibility that that record > could be deleted. > > So is there are way to get these rows a group at a time? > > There is also could be where clauses > > Thanks for any direction > > Randy > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
