INNODB_FT_DEFAULT_STOPWORD table holds a
list of stopwords that are
used by default when creating a
InnoDB table. For information about the
InnoDB stopword list and how to define
your own stopword lists, see Section 13.9.4, “Full-Text Stopwords”.
For related usage information and examples, see Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
Table 22.9 INNODB_FT_DEFAULT_STOPWORD Columns
SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD;+-------+ | value | +-------+ | a | | about | | an | | are | | as | | at | | be | | by | | com | | de | | en | | for | | from | | how | | i | | in | | is | | it | | la | | of | | on | | or | | that | | the | | this | | to | | was | | what | | when | | where | | who | | will | | with | | und | | the | | www | +-------+ 36 rows in set (0.00 sec)
You must have the
PROCESSprivilege to query this table.