Usar alias en un where

[David]

Puedes usar HAVING:

Código MySQL:

SELECT users_fullname, users_edad, (YEAR(CURRENT_DATE) - YEAR(users_edad)) - (RIGHT(CURRENT_DATE,5) < RIGHT(users_edad,5)) AS edad FROM ew_users HAVING edad BETWEEN 18 AND 25;
 

Saludos.