On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote: > > If I understand the manual correctly when I do a "select blah > from blah where blah = blah order by blah limit 10" Mysql finds > the first 10 matching records and then sorts those records. How > do I have it first sort the database and then take the first 10 > records? Just like with any other query, use an ORDER BY clause. LIMIT does not change this. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878 Fax: (408) 530-5454 Cell: (408) 439-9951 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
