What is fulltextsearch
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kishore
MATCH (col1,col2,...) AGAINST (expr [search_modifier])
A full-text index in MySQL is an index of type FULLTEXT.
Full-text indexes can be used only with MyISAM tables, and
can be created only for CHAR, VARCHAR, or TEXT columns. A
FULLTEXT index definition can be given in the CREATE TABLE
statement when a table is created, or added later using
ALTER TABLE or CREATE INDEX.
For large data sets, it is much faster to load your data
into a table that has no FULLTEXT index and then create the
index after that, than to load data into a table that has an
existing FULLTEXT index.
Full-text searching is performed using MATCH() ... AGAINST
syntax.
MATCH() takes a comma-separated list that names the columns
to be searched.
AGAINST takes a string to search for, and an optional
modifier that indicates what type of search to perform.
Three types of full-text searches
1. A Boolean search interprets the search string using the
rules of a special query language.
2. A natural language search interprets the search string as
a phrase in natural human language (a phrase in free text).
There are no special operators.
3. A query expansion search is a modification of a natural
language search.
Is This Answer Correct ? | 2 Yes | 0 No |
What type of errors can be occurred in php?
Is laravel easy to learn?
How to define a function with any number of arguments?
What is php and its advantages?
Which programming language does php resemble to?
What is curl php?
Which function is used in php to count the total number of rows returned by any query?
What is use of mysqli_query in php?
How to submit form without a submit button.
What is the expansion of LAMP?
Are objects passed by value or by reference?
What is beforeRender() used?