FULLTEXT INDEX is one of the more useful features in MySQL. Currently, MySQL allows FULLTEXT INDEX to create on non-binary string data types namely CHAR, VARCHAR, and TEXT. You can use these data types to have them FULLTEXT indexed. MySQL also allows to create FULLTEXT index on multi columns of such data types.