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 is strlen function in php?
Explain object-oriented methodology in php?
Which is the dependent variable?
What is an associative array?
How do you debug php?
What is the importance of "method" attribute in a html form?
What is mysqli php?
What is mysql_real_escape_string used for?
What is config file in php?
Which function you can use in php to open a file for reading or writing or for both?
Is python similar to php?
What is the Pipe Symbol represented?
What php framework does wordpress use?
What is helper library?
What is the different between count() and sizeof() in php?