Hello All I have two tables Table: 1 +-----------+----------+ | city | zip_code | +-----------+----------+ | New York | 12354 | | New York | 12355 | | New York | 12356 | | New York | 12357 | | New York | 12358 | | New York | 12359 | | New York | 12353 | +-----------+----------+
Table: 2 +------------+ | zip_code | +------------+ | 12345-1526 | +------------+ I am trying to work out the query to retrieve city name based on the zip code in the second table. How can I compare two strings? I tried LIKE in my query but it did not work. Thank you in advance for the help. -Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
