select * from name order by name limit 500,100
will select records 500-599 (inclusive)
Fraser MacKenzie (fraserm@stripped)
---------------- (ICQ: 15389075)
Rondak's Portal (http://www.rondaksportal.com/)
What do you want to play today?
On Wed, 6 Oct 1999, Ed Carp wrote:
> On Wed, 6 Oct 1999, Davor Cengija wrote:
>
> > On Wed, 6 Oct 1999, Yingyao Zhou wrote:
> >
> > > select * from name order by name;
> >
> > select * from name order by name limit 100;
>
> I don't think that's what he meant. If I have 1000 records, how do I
> select records 500-600?
> --
> Ed Carp, N7EKG erc@stripped 940/367-2744 cell phone
>
> Visit http://www.linux-usa.net - Plug-n-Go Linux servers for small business
> "Plug it in - Turn it on - You're Done!"
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15311@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>
