[MYSQL] Where con un alias?

[pezzo]

Ho appena trovato la risposta nel manuale di MYSQL:

Standard SQL doesn't allow you to refer to a column alias in a WHERE clause. This restriction is imposed because when the WHERE code is executed, the column value may not yet be determined.

E quindi come si fa?