At 20:48 +0100 3/30/02, Roger Baklund wrote: >* 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
Yeah, you're right. Duh. Thanks for pointing that out. > >-- >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