Archive | March, 2009

mysql “having” vs “where”

13 Mar

if you are using “group by’s” – use “having”

You may use Alias’s if you use HAVING instead of WHERE this is one of the defined differences between the two clauses. Having is also slower and will not be optimized, but if you are placing a complex function like this in your where you obviously aren’t expecting great speed.”