Is there something wrong with my MySQL query?
This query is refusing to run:
SELECT CONCAT_WS( ’ ’, first_name, last_name ) AS full_name, username, country, region, CONCAT_WS( ’, ’, region, country ) AS location FROM people WHERE full_name=‘John Doe’
Unknown column ‘full_name’ in ‘where clause’
Am I missing something? I can order by full_name, but cannot use it in a where clause. I’ve spent a while looking for some documentation on this, but I can’t seem to find anything that covers it.
Any help is greatly appreciated!
This question is in the General Section. Responses must be helpful and on-topic.