How to change a MySQL collation to make it searchable case-insensitive
When a table has the collation utf8_bin it is not searchable case-insensitive.
Run the following SQL statement to change the collation:
ALTER TABLE `MyTable` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;