Interested to Buy Any Domain ? << Click Here >> for more details...
What is fulltextsearch
- 2 Answers
- 7242 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 are the advantages of stored procedures?
Is echo a function in php?
Explain mysql_errno()?
How can we extract string 'abc.com' from a string "http://info@abc.com" using regular expression of PHP
"mysql_fetch_row — Get a result row as an enumerated array",this sentence comes from the PHP offical manual.However ,i can not understand the words "enumerated array".I need some help.Thanks a lot to everyone that reply.
What is meant by nl2br()?
4 Answers Rushmore Consultancy,
Is null empty php?
what is the url rewriting?how to rewrite the url? give any example
How can we know the count/number of elements of an array?
What is the best way to change the key without changing the value of a php array element?
How to create a web form?
What is $_ request?
PHP 
