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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]