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 ?

David

-----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

Thanks,

-Mike



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread125872@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-dshanes=san.rr.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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