List:General Discussion« Previous MessageNext Message »
From:David Shanes Date:November 26 2002 6:37pm
Subject:RE: LIMIT in MySQL
View as plain text  
It is starting at record 30 and sending you the next 60 records.
Maybe you want LIMIT 30, 30 ?


-----Original Message-----
From: Mike At Spy [mailto:spycobalt@stripped] 
Sent: Tuesday, November 26, 2002 9:56 AM
To: mysql@stripped
Subject: LIMIT in MySQL

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



Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread125872@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try:

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