What is fulltextsearch
- 2 Answers
- 6124 Views
- A1 Technology, I also Faced
- E-Mail Answers
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 is the sign to start variables in PHP?
What interest would a "work-for-ownership" offer receive from PHP/MySQL developers?
Where sessions stored in PHP?
can you give me an example code of calling java script function in php variable using AJAX.or with out ajax??????
What's the difference between using mysql_ functions and pdo?
how to maintained the session from one page to another page based on the url and then entered into the first page is logging into instead of secondpage it goes to the another url.ie first login session togoes to the one url and next login session it goes to another url how is it possible in php please give me answer in that question
when ever the user logged in the database table the current registered date will be appeared
What is faster in php?
How can we check the value of a given variable is alphanumeric?
Difference between mysql_connect and mysql_pconnect?
How could I install codeignitor ?
How check submit button is clicked in php?
PHP 
