MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Mike At Spy Date:November 26 2002 5:56pm
Subject:LIMIT in MySQL
View as plain text  
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

Thanks,

-Mike


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