>>>>> "Curt" == Curt W Zirzow <curt@stripped> writes:
Curt> I noticed that in the latest version of mysql that you no longer can
Curt> use the column alias inside the where clause. Does this (ie. In the
Curt> following query) cause the function be called in both cases or would
Curt> it be called once and aliased in the where clause?
Curt> select function(column) as column_alias
Curt> from table
Curt> where function(column) > 0
The above has never worked in any MySQL version and is not even
allowed according to the ANSI SQL standard.
PS: You can always use HAVING ...