Re: selecting a range of records from my result set

2003-01-07 Thread Bart Lateur
On Mon, 06 Jan 2003 09:59:41 -0700, Ian Harisay wrote: In mysql is it possible to retrieve records 50-75 from your result set? Yes. Add a LIMIT clause to your SELECT statement. SELECT * FROM table LIMIT 50,25 It works well from within DBI (but don't append the semi-colon at the end of

RE: selecting a range of records from my result set

2003-01-07 Thread wiggins
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