Check out 'LIMIT' in the MySQL docs. It should be able to handle exactly what you want.
http://danconia.org ------------------------------------------------ On Mon, 06 Jan 2003 09:59:41 -0700, "Ian Harisay" <[EMAIL PROTECTED]> wrote: > Hi all, > > This is really a mysql question rather than a dbi question. So, I > apologize to everyone in advance. > > In mysql is it possible to retrieve records 50-75 from your result set? > Say my result set is 20,000 records. I would like to do this and > provide an index for the client to walk thru. I have already done > something, but it requires looping through my result set until I have > the range of records I want to display. Oracle has a nice rownum > feature to make life pleasant. > > Thanks for the help, > > Ian >
