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? > LIMIT is applied after sorting. It does what you want already. --------------------------------------------------------------------- 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
