* Paul DuBois
> At 13:06 -0800 3/30/02, destr0 wrote:
> >a select query issued on a table with an autoincremented field
> and no ORDER
> >clause seems to default to having it's results returned in order of the
> >autoincremented field, ASC. I was saying "records 30 - 45" in terms of
> >that.
>
> What you're seeing is purely coincidence and should NOT be relied on.
> But in this case, why don't you simply do:
>
> SELECT .... ORDER BY id, col1, col2, ... LIMIT 29, 16
That would return the records in the order of the id field... try this:
SELECT ...
WHERE ... AND
id BETWEEN 30 AND 45
ORDER BY col1, col2
--
Roger
query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
