What is fulltextsearch




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




More PHP Interview Questions

Explain what does $_files means?

0 Answers  


Tell me what kind of things have you done on the social side?

0 Answers  


Is null check in php?

0 Answers  


How to implement a class named dragonball. This class must have an attribute named ballcount (which starts from 0) and a method ifoundaball. When ifoundaball is called, ballcount is increased by one. If the value of ballcount is equal to seven, then the message you can ask your wish is printed, and ballcount is reset to 0. How would you implement this class?

0 Answers  


Are there regular expressions in php?

0 Answers  






How to print \ in php. Only \ with out using . or *.

7 Answers   American Solutions,


How are variables declared in php?

0 Answers  


what are interfaces and Abstart classes

0 Answers   Net Solution,


How to add different images in php program like a job site.......

2 Answers  


Is php object oriented?

0 Answers  


Is php still in demand?

0 Answers  


What is the use of addslashes in php?

0 Answers  






Categories