SQL: Why doesn't Where see the new column?

Question

SQL

Hello. I have code:

SELECT CONCAT_WS(' ', first_name, last_name) AS name_user
FROM users_info
WHERE (name_user LIKE '%а%')

I also have an error in this code. Error: "#1054 - Unknown column 'name_user' in 'where clause'"
Q: Why doesn't Where see the new column? How to fix? Or how to do it differently?

Answer 1

HAVING instead of WHERE should help.