Filter out Country with CHine and China

I have some thousand addresses in China, and some of them at with TWO capitals as CHina and other are the normal ONE capital China.

How to filter out the ones with TWO capitals ? Tried %CHina% but that does not work…

Thanks for solution…!

William R.

This actually depends on database collations underneath.

When you use the “%” operator it’s hard to get it to make a case-sensitive search.

From the database (phpMyAdmin) it’s easier with the BINARY keyword:

SELECT * FROM table WHERE BINARY column = ‘value’

So if you just want to find all “CHina” 's to replace them with “China” 's, I would try it from the database.