Full-Text Stopwords if one of these documents contains the word “databases”  and the word “MySQL” , the second search finds the documents that contain the word “MySQL”  even if they do not contain the word “database” . The following example shows this difference: Another example could be searching for books by Georges Simenon about Maigret, when a user is not sure how to spell “Maigret” . A search for “Megre and the reluctant witnesses”  finds only “Maigret and the Reluctant Witnesses”  without query expansion. A search with query expansion finds all books with the word “Maigret”  on the second pass. Because blind query expansion tends to increase noise significantly by returning nonrelevant documents, use it only when a search phrase is short. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the  character_set_server  and  collation_server  system variables). False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from  character_set_server  or collation_server . Case sensitivity of stopword lookups depends on the server collation. For example, lookups are case- insensitive if the collation is  utf8mb4_0900_ai_ci , whereas lookups are case-sensitive if the collation is utf8mb4_0900_as_cs  or  utf8mb4_bin . InnoDB  has a relatively short list of default stopwords, because documents from technical, literary, and other sources often use short words as keywords or in significant phrases. For example, you might search for “to be or not to be”  and expect to get a sensible result, rather than having all those words ignored. 2213 Stopwords for InnoDB Search Indexes 12.10.4 Full-Text Stopwords Note mysql>  SELECT * FROM articles WHERE MATCH (title,body) AGAINST (’database’ IN NATURAL LANGUAGE MODE); +----+-------------------+------------------------------------------+ | id | title | body | +----+-------------------+------------------------------------------+ | 1 | MySQL Tutorial | DBMS stands for DataBase ... | | 5 | MySQL vs. YourSQL | In the following database comparison ... | +----+-------------------+------------------------------------------+ 2 rows in set (0.00 sec) mysql>  SELECT * FROM articles WHERE MATCH (title,body) AGAINST (’database’ WITH QUERY EXPANSION); +----+-----------------------+------------------------------------------+ | id | title | body | +----+-----------------------+------------------------------------------+ | 5 | MySQL vs. YourSQL | In the following database comparison ... | | 1 | MySQL Tutorial | DBMS stands for DataBase ... | | 3 | Optimizing MySQL | In this tutorial we show ... | | 6 | MySQL Security | When configured properly, MySQL ... | | 2 | How To Use MySQL Well | After you went through a ... | | 4 | 1001 MySQL Tricks | 1. Never run mysqld as root. 2. ... | +----+-----------------------+------------------------------------------+ 6 rows in set (0.00 sec) •Stopwords for InnoDB Search Indexes •Stopwords for MyISAM Search Indexes