This is the PHP mailing list, not the SQL mailing list ;) but here is the syntax ( not tested ): SELECT c.name AS city FROM geodb_locations AS c, user AS u WHERE u.user_id = 4 AND c.plz LIKE u.plz; > 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
