List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 26 2002 6:37pm
Subject:Re: LIMIT in MySQL
View as plain text  
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
Thread
LIMIT in MySQLMike At Spy26 Nov
  • RE: LIMIT in MySQLDavid Shanes26 Nov
  • Re: LIMIT in MySQLPaul DuBois26 Nov
  • RE: LIMIT in MySQLJim Esten26 Nov
    • Re: LIMIT in MySQLRodney Broom26 Nov
  • Re: LIMIT in MySQLBenjamin Pflugmann26 Nov
  • RE: LIMIT in MySQLJennifer Goodie26 Nov
  • Re: LIMIT in MySQLMatthew Baranowski26 Nov
  • Re: LIMIT in MySQLRay26 Nov
  • Re: LIMIT in MySQLSteve Edberg26 Nov