Pre-Requisites:

1. MySQL 3.23.23 or higher (for natural-language full-text searching) or MySQL 4 or higher (for Boolean full-text searching)

2. Requires an index of type FULLTEXT on table [ ALTER TABLE <table_name> ADD FULLTEXT(<column_name>);]

3. Full-text indexes can be used only with MyISAM tables

4. Only applied on columns having following type: CHAR, VARCHAR, or TEXT

5. The index doesn’t contain every word

6. A list of ‘stopwords’ are ignored from being indexed. (Common words in English language) [ Solution: Check ft_stopword_file, can be replaced with an external file ]

7. Index ignores words unless they’re longer than ft_min_word_len and shorter than ft_max_word_len characters

8. A column that uses the latin1 character set of can be assigned a collation of latin1_bin to make it case sensitive for full-text searches. Otherwise, case-insensitive search will be performed




Usage:

SELECT <field1>,<field2>,... FROM <table_name> WHERE <condition> AND MATCH(<field_name>) AGAINST(<value>)

_________________
http://sphinxstudio.com/