List:General Discussion« Previous MessageNext Message »
From:Curt W. Zirzow Date:March 24 1999 8:04pm
Subject:Query performance with functions
View as plain text  
Hello,

 I noticed that in the latest version of mysql that you no longer can 
use the column alias inside the where clause. Does this (ie. In the 
following query) cause the function be called in both cases or would 
it be called once and aliased in the where clause? 

select function(column) as column_alias
from table
where function(column) > 0

Curt.


Thread
Query performance with functionsCurt W. Zirzow25 Mar
  • Query performance with functionsMichael Widenius25 Mar
    • Re: Query performance with functionsEric Savage25 Mar