Best case-insensitive search for Character Set utf8 COLLATE utf8_bin Columns.

[Robert DiFalco]

What is the best (most optimal) way to perform a case-insensitive search
for a VARCHAR column with COLLATE utf8_bin?

I'm assuming the answer is not:

	SELECT * 
	FROM MyTable 
	WHERE UPPER(MyColumn) LIKE Upper('%pattern%');

Tia!

R.