Posted by Sean on 04/04/07 15:27

"lallous" <lallous@lgwm.org> wrote in message
news:1175697591.472528.25070@w1g2000hsg.googlegroups.com...
> Hello
>
> I have a small MySQL query like this:
>
> [code]
> SELECT
> CONCAT(users.description, ' ', users.address) AS x
> FROM
> users
> WHERE
> x LIKE '%something_to_match_here%'
>
> [/code]
>
> MySQL 3.x is complaining about complaining about the use of "x" saying
> that it is not a valid column name. Is there is a way to make this
> work or something similar?
>
> --
> Elias
>


I think that it should be...

SELECT CONCAT(users.description, ' ', users.address) AS x
FROM users
HAVING x LIKE '%something_to_match_here%'

• Next in forum: Re: MySQL 3.x and SELECT / WHERE
• Prev in forum: MySQL 3.x and SELECT / WHERE
• Thread view: Re: MySQL 3.x and SELECT / WHERE

[Reply to this message]