Boolean Full-Text Searches The search result is empty because the word “MySQL”  is present in at least 50% of the rows, and so is effectively treated as a stopword. This filtering technique is more suitable for large data sets, where you might not want the result set to return every second row from a 1GB table, than for small data sets where it might cause poor results for popular terms. The 50% threshold can surprise you when you first try full-text searching to see how it works, and makes  InnoDB  tables more suited to experimentation with full-text searches. If you create a  MyISAM  table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. As a result, no search returns any results until the table contains more rows. Users who need to bypass the 50% limitation can build search indexes on  InnoDB  tables, or use the boolean search mode explained in Section 12.10.2, “Boolean Full-Text Searches” . WHERE MATCH (title,body) AGAINST (’MySQL’ IN NATURAL LANGUAGE MODE); Empty set (0.00 sec) 12.10.2 Boolean Full-Text Searches MySQL can perform boolean full-text searches using the  IN BOOLEAN MODE  modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the  +  and  -  operators indicate that a word must be present or absent, respectively, for a match to occur. Thus, the query retrieves all the rows that contain the word “MySQL”  but that do  not contain the word “YourSQL” : mysql>  SELECT * FROM articles WHERE MATCH (title,body) AGAINST (’+MySQL -YourSQL’ IN BOOLEAN MODE); +----+-----------------------+-------------------------------------+ | id | title | body | +----+-----------------------+-------------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | | 2 | How To Use MySQL Well | After you went through a ... | | 3 | Optimizing MySQL | In this tutorial, we show ... | | 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... | | 6 | MySQL Security | When configured properly, MySQL ... | +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as  implied Boolean logic , in which • +  stands for  AND • -  stands for  NOT •[ no operator ] implies  OR Boolean full-text searches have these characteristics: •They do not automatically sort rows in order of decreasing relevance. • InnoDB  tables require a  FULLTEXT  index on all columns of the  MATCH()  expression to perform boolean queries. Boolean queries against a  MyISAM  search index can work even without a  FULLTEXT  index, although a search executed in this fashion would be quite slow. •The minimum and maximum word length full-text parameters apply to  FULLTEXT  indexes created using the built-in  FULLTEXT  parser and MeCab parser plugin.  innodb_ft_min_token_size  and 2207