Full-Text Stopwords To see the default  InnoDB  stopword list, query the INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD  table. To define your own stopword list for all  InnoDB  tables, define a table with the same structure as the  INNODB_FT_DEFAULT_STOPWORD  table, populate it with stopwords, and set the value of the innodb_ft_server_stopword_table  option to a value in the form  db_name / table_name  before creating the full-text index. The stopword table must have a single  VARCHAR  column named  value . The following example demonstrates creating and configuring a new global stopword table for  InnoDB . 2214 -- Create a new stopword table mysql> CREATE TABLE my_stopwords(value VARCHAR(30)) ENGINE = INNODB; Query OK, 0 rows affected (0.01 sec) -- Insert stopwords (for simplicity, a single stopword is used in this example) mysql> INSERT INTO my_stopwords(value) VALUES (’Ishmael’); Query OK, 1 row affected (0.00 sec) -- Create the table mysql> CREATE TABLE opening_lines ( id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, mysql> 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)