Merlin wrote: > 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%";
I believe you want something not unlike this:
WHERE u.user_id = 4
AND c.plz LIKE concat('%', u.plz, '%')
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

