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
What are the new features in php 7?
What is the difference between public, protected and private?
What is a session in php?
How is csrf token generated?
Explain what is the difference between for and foreach?
Php program to generate fibonacci series?
What is slim framework?
What is htaccess? Why do we use this and where?
What is good average session duration?
How to find the index of an element in an array php?
How to find current date and time?
Does empty check for null?
What is the difference between nowdoc and heredoc?
How do you create an array in php?
How do you pass a variable by value in php?