Posted by ZeldorBlat on 04/04/07 15:52

On Apr 4, 10:39 am, "lallous" <lall...@lgwm.org> wrote:
> 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

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

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

[Reply to this message]