Re: string comparison query

2003-12-07 Thread Chris Elsworth
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.

2001-12-23 Thread Heo, Jungsu Mr.
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" ; +--+ | "