Re: LIMIT in MySQL

[Paul DuBois]

At 12:56 -0500 11/26/02, Mike At Spy wrote:
>I must not be awake yet.  Why is this query sending me back 60 records?
>Shouldn't it only send back records 30 through 60 (i.e. 30 records)?
>
>SELECT * FROM table ORDER BY somefield LIMIT 30,60

No.

30 = number of records to skip
60 = number of records to return.

You're probably thinking that the numbers define a range, but they don't.

>
>Thanks,
>
>-Mike


sql, query