LIKE query works for number but not for character

[elabuwa]

Hi guys,

 

When I run the below query it works when I use a number for the "account" like part, but if I run a letter like "a" or "A" it returns no results.

 

Works

SELECT company,contact,booking_id,date_created,camp_id FROM campaign_summary WHERE uid='1' AND account LIKE '5%' AND type='P'

 

Does NOT work

SELECT company,contact,booking_id,date_created,camp_id FROM campaign_summary WHERE uid='1' AND account LIKE 'a%' AND type='P'

Any idea? :wtf:

 

FYI, the table has records where the account field has records begining from "a".

Field is VARCHAR

[PFMaBiSmAd]

Are you sure you don't have a white-space/non-printing character before the 'a' in the data?

 

You would need to dump the database record that you think the query should match and examine it to make sure that all the data is actually what you think. The uid, account, or type might not actually be what the query is trying to find.

 

[fenway]

Are you sure you don't have a white-space/non-printing character before the 'a' in the data?

Easy to check -- use LOCATE().