What is fulltextsearch

Question Posted / rohit singh

2 Answers
6105 Views
A1 Technology, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is fulltextsearch..

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

What is fulltextsearch..

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

Post New Answer