keyur.delhi Posted February 15, 2010 Share Posted February 15, 2010 Pre-Requisites: MySQL 3.23.23 or higher (for natural-language full-text searching) or MySQL 4 or higher (for Boolean full-text searching) Requires an index of type FULLTEXT on table [ ALTER TABLE <table_name> ADD FULLTEXT(<column_name>);] Full-text indexes can be used only with MyISAM tables Only applied on columns having following type: CHAR, VARCHAR, or TEXT The index doesn’t contain every word 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 ] Index ignores words unless they’re longer than ft_min_word_len and shorter than ft_max_word_len characters 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>) Quote Link to comment Share on other sites More sharing options...
fenway Posted February 16, 2010 Share Posted February 16, 2010 Huh? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.