Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
Why do we use query?
Is jquery better than javascript?
What is the difference between characters 23 and x23?
Define metaphone()?
What is $row in php?
Differentiate echo vs. Print statement.
How can you submit a form without a submit button?
What is the difference between get and post method in php?
What is a session in php?
Explain me what is the goto statement useful for?
Write a php script to get the largest key in an array?
What is the Pipe Symbol represented?
What is cURL in PHP?
Difference between mysql_connect and mysql_pconnect?
iam mca post graduate in 2010 not getting job in JAVA so iam looking for carear in php as market demand is high so it is best option to try for php or not
