Re: Talking Limit

2005-09-08 Thread Alec . Cawley 
'Yemi Obembe [EMAIL PROTECTED] wrote on 08/09/2005 10:33:25:

 Talking limit (in select query), does it limit the search result 
 after ordering according to relevancy and the likes, or before?
 thanks

LIMIT operates after ORDER BY.

Alec 

 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Talking Limit

2005-09-08 Thread Gleb Paharenko 
Hello.



Have a look here:

  http://dev.mysql.com/doc/mysql/en/limit-optimization.html





'Yemi Obembe [EMAIL PROTECTED] wrote:

 [-- text/plain, encoding 8bit, charset: iso-8859-1, 7 lines --]

 

 Talking limit (in select query), does it limit the search result after 
 ordering according to relevancy and the likes, or before?

 thanks

 

 



 -

 Click here to donate to the Hurricane Katrina relief effort.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]