select ONLY records 51-100 in a MySQL table

crmpicco · February 24th, 2005, 07:14 AM

How do i select ONLY records 51-100 in a MySQL table called trip_master?

something along the lines of:

select * from trip_master limit 51,100;

but this doesnt work...

www.crmpicco.co.uk

ChrisScott · February 24th, 2005, 07:19 AM

The second parameter of the LIMIT clause is the number of records to return, not the upper range - set it to 50 rather than 100 and it should work fine.

HTH,

Chris

crmpicco · February 24th, 2005, 07:21 AM

select * from trip_master limit 50,50;

www.crmpicco.co.uk