mysql use alias in where clause code example

Example: alias mysql

SELECT coluna
AS alias_coluna
FROM tabela AS alias_tabela;