No kidding. I didn't know that. Thanks a lot! Regards, Jake Johnson [EMAIL PROTECTED]
______________________________________________________________________ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Mon, 14 Jul 2003, Gabriel Guzman wrote: > On Mon, 2003-07-14 at 17:44, Jake Johnson wrote: > > Be careful! Phil wanted the top 20 and the limit 20 will only return a > > random 20 records. > > Actually, LIMIT x will return the first x rows of a query, not random > records. In fact, you can even combine ORDER BY and LIMIT if you want > to get the first x rows of some order. > > http://www.mysql.com/doc/en/SELECT.html > http://www.mysql.com/doc/en/LIMIT_optimisation.html > > gabe. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]