List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 5 2001 12:41am
Subject:Re: Limit
View as plain text  
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.
LimitMat Murdock5 Apr
  • Re: LimitPaul DuBois5 Apr
    • Re: Limithooker5 Apr
      • Re: LimitDan Nelson5 Apr
  • Re: LimitJeremy Zawodny5 Apr
  • Re: LimitDan Nelson5 Apr