sql syntax problem

[Merlin <news.groups@xxxxxx>]

Hello everybody,

I am trying to create a sql query with php and I do have a syntax problem with 
the mysql query.
One row is called "plz" and I would like to search for a value inside that with 
a like statement. Problem is, the system takes the u.plz as a character not as a 
table element:

LIKE  "%u.plz%"

Has anybody an idea how the correct sytnax is? I am lost here.

Thank you in advance,

Merlin

PS: This is the complete statement:
SELECT c.name AS city
FROM geo_de.geodb_locations AS c, fix.user AS u
WHERE u.user_id =4 AND c.plz
LIKE  "%u.plz%";

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php