selecting unique line in db

[Anon]

i want to select certain records from a db, it's ok if i sort them into order then use LIMIT 5 to select the first 5 but how would i set up my script to select the next 5-10 records in a query ?? or even 23-27 ??

any help greatly received

thanks

darren

[Anon]

I believe LIMIT and OFFSET are what you are looking for.....

SELECT * FROM table ORDER BY field LIMIT 5 OFFSETT 5;

SELECT * FROM table ORDER BY field LIMIT 5 OFFSETT 23;

[lawnmowerman]

Actually, at least as MySQL is concerned, limits
are done a little differently:

SELECT * FROM table ORDER BY field LIMIT <offset>,<count>;

SELECT * FROM table ORDER BY field LIMIT 23,5;
would select rows 23-27.

SELECT * FROM table ORDER BY field LIMIT 23;
would select rows 0-23 since a single param to LIMIT is interpretted as 'LIMIT 0,<number>'

-Rich