AConvert the column to TEXT and add a fulltext index to the table
BCreate multiple prefix indexes of differing lengths
CConvert their column to BINARY
DRedesign the table so that the most commonly searched for string patterns are in their own columns