Send to a Friend

richardhenry's avatar

Is there something wrong with my MySQL query?

Asked by richardhenry (12692points) July 9th, 2008

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!

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.