Posted by lallous on 04/04/07 14:39

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

• Next in forum: Re: MySQL 3.x and SELECT / WHERE
• Prev in forum: form text é->éé in MySQL
• Thread view: MySQL 3.x and SELECT / WHERE

[Reply to this message]