Interested to Buy Any Domain ? << Click Here >> for more details...
What is fulltextsearch
- 2 Answers
- 7037 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 output of the ucwords function in this example?
How to define a function with any number of arguments?
How can we define a variable accessible in functions of a php script?
what are in image creating functions in php
what is the difference between ph4 and php5
What does $_env means?
Explain Constant in Class?
What are the ways we can destroy a session variable ?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
How I use global variable in another page without using $_GET method?
Which is better #define or enum?
What are the rules to declare a php variables?
PHP 
