Re: Select in groups of 5

2001-08-27 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 18:32:57 -0500 >From |"Tyler Longrne" <[EMAIL PROTECTED]> Hello! TL> Hello everyone, TL> Is there any way to make selections in groups of 5. I want to get 5 record TL> sets at a time until we get to a point that there's 4 or less records. TL> Thank you everyone, TL> Tyl

RE: Select in groups of 5

2001-08-27 Thread Cal Evans
Select * from yourTable limit 0,5 gets you the first 5. After that: Select * from yourTable limit 5,5 gets you the next five...etc. Cal http://www.calevans.com -Original Message- From: Tyler Longrne [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 6:33 PM To: MySQL List Subj