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]

Reply via email to