|
||
On what data types fulltext index can be created?I want to have my table FULLTEXT indexed for searching data from it faster. So, I am in need to know that on what field data types FULLTEXT INDEX can be created? Answer No: 124FULLTEXT 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. Related MySQL FAQs to the Above FAQ
|
