Re: Use (problem with?) LIMIT in select statement

[Thimble Smith]

On Wed, 11 Aug 1999, Paul McAvoy wrote:
> SELECT id,name FROM list ORDER BY name LIMIT 20;
>
> I was under the impression that teh LIMIT clause was used to limit the
> return set.

Paul, can you show a complete example of MySQL limiting the return
set before ordering the rows?  I haven't been able to reproduce your
problem, and maybe I don't understand exactly what behavior you are
seeing / expecting.

Tim