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;