Full-Text Stopwords opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200) ) ENGINE=InnoDB; Query OK, 0 rows affected (0.01 sec) -- Insert data into the table mysql> INSERT INTO opening_lines(opening_line,author,title) VALUES (’Call me Ishmael.’,’Herman Melville’,’Moby-Dick’), (’A screaming comes across the sky.’,’Thomas Pynchon’,’Gravity\’s Rainbow’), (’I am an invisible man.’,’Ralph Ellison’,’Invisible Man’), (’Where now? Who now? When now?’,’Samuel Beckett’,’The Unnamable’), (’It was love at first sight.’,’Joseph Heller’,’Catch-22’), (’All this happened, more or less.’,’Kurt Vonnegut’,’Slaughterhouse-Five’), (’Mrs. Dalloway said she would buy the flowers herself.’,’Virginia Woolf’,’Mrs. Dalloway’), (’It was a pleasure to burn.’,’Ray Bradbury’,’Fahrenheit 451’); Query OK, 8 rows affected (0.00 sec) Records: 8 Duplicates: 0 Warnings: 0 -- Set the innodb_ft_server_stopword_table option to the new stopword table mysql> SET GLOBAL innodb_ft_server_stopword_table = ’test/my_stopwords’; Query OK, 0 rows affected (0.00 sec) -- Create the full-text index (which rebuilds the table if no FTS_DOC_ID column is defined) mysql> CREATE FULLTEXT INDEX idx ON opening_lines(opening_line); Query OK, 0 rows affected, 1 warning (1.17 sec) Records: 0 Duplicates: 0 Warnings: 1 Verify that the specified stopword (’Ishmael’) does not appear by querying the words in INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE . Note By default, words less than 3 characters in length or greater than 84 characters in length do not appear in an  InnoDB  full-text search index. Maximum and minimum word length values are configurable using the  innodb_ft_max_token_size  and innodb_ft_min_token_size  variables. This default behavior does not apply to the ngram parser plugin. ngram token size is defined by the  ngram_token_size option. mysql> SET GLOBAL innodb_ft_aux_table=’test/opening_lines’; Query OK, 0 rows affected (0.00 sec) mysql> SELECT word FROM INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE LIMIT 15; +-----------+ | word | +-----------+ | across | | all | | burn | | buy | | call | | comes | | dalloway | | first | | flowers | | happened | | herself | | invisible | | less | | love | | man | 2215