What is fulltextsearch

Answer Posted / jagpreet

MySQL has support for full-text indexing and searching. A
full-text index in MySQL is an index of type FULLTEXT.
FULLTEXT indexes can be used only with MyISAM tables; they
can be created from CHAR, VARCHAR, or TEXT columns as part
of a CREATE TABLE statement or added later using ALTER
TABLE or CREATE INDEX. For large datasets, it is much
faster to load your data into a table that has no FULLTEXT
index, and then create the index afterwards, than to load
data into a table that has an existing FULLTEXT index.

Constraints on full-text searching are listed in Section
12.7.4, “Full-Text Restrictions”.

Full-text searching is performed with the MATCH() function.

mysql> CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY
KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features in php 7?

474


What is the difference between public, protected and private?

463


What is a session in php?

543


How is csrf token generated?

494


Explain what is the difference between for and foreach?

504






Php program to generate fibonacci series?

527


What is slim framework?

483


What is htaccess? Why do we use this and where?

478


What is good average session duration?

522


How to find the index of an element in an array php?

500


How to find current date and time?

473


Does empty check for null?

525


What is the difference between nowdoc and heredoc?

514


How do you create an array in php?

525


How do you pass a variable by value in php?

522