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 the function in PHP do not return a timestamp?
What is the difference between php4 and php5?
How to track no of user logged in?
What does $_cookie means?
Explain the installation of PHP on UNIX systems?
How many types of php are there?
What is $_ files in php?
How can we connect to a mysql database from a php script?
How do you display the output directly to the browser?
How does one prevent the following warning ‘warning: cannot modify header information – headers already sent' and why does it occur in the first place?
What is the purpose of $_ session?
how to open & closing opening period in fico
How should a model be structured in mvc?
How do you check is php not empty?
Tell me what is the definition of a session?
