Boolean Full-Text Searches 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. • + • - •(no operator) • @ 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) 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. 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.” 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. 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. The boolean full-text search capability supports the following operators: 2208