MySQL VARCHAR strange column behavior
- by Mat
I have the following SQL statement which returns a single record as expected:
select * from geodatasource_cities C,
geodatasource_countries D
where C.CC_FIPS = D.CC_FIPS
and D.CC_ISO='AU'
and UCASE(TRIM(C.FULL_NAME_ND)) LIKE '%JAN JUE%';
However, If I use the following SQL statement, no records are returned. I have only changed the LIKE clause to an equal to clause:
select * from geodatasource_cities C,
geodatasource_countries D
where C.CC_FIPS = D.CC_FIPS
and D.CC_ISO='AU'
and UCASE(TRIM(C.FULL_NAME_ND)) = 'JAN JUE';
Can anybody please help me understand why this may be happening?
