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
