innodb_ft_max_token_size  are used for InnoDB  search indexes. ft_min_word_len  and ft_max_word_len  are used for MyISAM  search indexes. 

Minimum and maximum word length full-text parameters do not apply to FULLTEXT  indexes created using the ngram parser. ngram token size is defined by the ngram_token_size  option. 

•The stopword list applies, controlled by innodb_ft_enable_stopword , innodb_ft_server_stopword_table , and innodb_ft_user_stopword_table  for InnoDB search indexes, and ft_stopword_file  for MyISAM  ones. 

• InnoDB  full-text search does not support the use of multiple operators on a single search word, as in this example: ’++apple’ . Use of multiple operators on a single search word returns a syntax error to standard out. MyISAM full-text search successfully processes the same search, ignoring all operators except for the operator immediately adjacent to the search word. 

• InnoDB  full-text search only supports leading plus or minus signs. For example, InnoDB  supports ’+apple’  but does not support ’apple+’ . Specifying a trailing plus or minus sign causes InnoDB  to report a syntax error. 

• InnoDB  full-text search does not support the use of a leading plus sign with wildcard ( ’+*’ ), a plus and minus sign combination ( ’+-’ ), or leading a plus and minus sign combination ( ’+-apple’ ). These invalid queries return a syntax error. 

• InnoDB  full-text search does not support the use of the @  symbol in boolean full-text searches. The @ symbol is reserved for use by the @distance  proximity search operator. 

•They do not use the 50% threshold that applies to MyISAM  search indexes. 

The boolean full-text search capability supports the following operators: 

• + 

A leading or trailing plus sign indicates that this word must  be present in each row that is returned. 

InnoDB  only supports leading plus signs. 

• - 

A leading or trailing minus sign indicates that this word must not  be present in any of the rows that are returned. InnoDB  only supports leading minus signs. 

Note: The -  operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by -  returns an empty result. It does not return “all rows except those containing any of the excluded terms.” 

•(no operator) 

By default (when neither +  nor -  is specified), the word is optional, but the rows that contain it are rated higher. This mimics the behavior of MATCH() AGAINST()  without the IN BOOLEAN MODE  modifier. 

• @ distance 

This operator works on InnoDB  tables only. It tests whether two or more words all start within a specified distance from each other, measured in words. Specify the search words within a double-quoted string immediately before the @ distance  operator, for example, MATCH(col1) AGAINST(’"word1 word2 word3" @8’ IN BOOLEAN MODE) 

• > < 

