无法使用关键字搜索记录，但关键字存在于MySQL的表中

I have city table with structure as -

#   Name         Type           Collation
1   cityId       int(11)            
2   countryCode  char(5)        latin1_swedish_ci
3   cityName     varchar(100)   utf8mb4_unicode_ci
4   lat          varchar(20)    latin1_swedish_ci
5   lng          varchar(20)    latin1_swedish_ci

I have cities for 'countryCode' - 'ad' like -

cityId countryCode cityName   lat        lng
1      ad          Aixàs      42.4833333 1.4666667
2      ad          Aixirivali 42.4666667 1.5
3      ad          Aixirivall 42.4666667 1.5
4      ad          Aixirvall  42.4666667 1.5
5      ad          Aixovall   42.4666667 1.4833333

But when i execute a query - SELECT * FROM city WHERE countryCode = 'ad', I get empty data. I imported this data from excel sheet having almost 32,00,000 records. I have checked that there is no space before or after the country code. Is there any issue with the collation ? Do i need to do some some conversion ? Please help.

Try collate the text You are searching like that:

  SELECT * FROM city WHERE countryCode = 'ad' COLLATE latin1_swedish_ci