[单选题]Your developers have created table to store some o

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