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’

Returning:

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!

Topics: computers, programming, development, PHP, code, web development, application, coding