RE: LIMIT, ORDER Dilema

[Paul DuBois]

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