Re: string comparison query
On Sun, Dec 07, 2003 at 12:11:21AM -0500, Alex Khordos wrote: > > 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. Use SUBSTRING to cut down the extended zipcode to 5
Re : String comparison.
You should use "binary" attribute. mysql> select binary "fff " = "fff" ; +-+ | binary "fff " = "fff" | +-+ | 0 | +-+ 1 row in set (0.28 sec) mysql> select "fff " = "fff" ; +--+ | "