Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- View default InnoDB stop words SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD; -- Custom stop word table (my.cnf) -- innodb_ft_server_stopword_table = mydb/my_stopwords -- Then reload: ALTER TABLE articles DROP INDEX idx_search; -- ALTER TABLE articles ADD FULLTEXT idx_search(title, body);
Result
Open