Someone at work did a four word search where every word was part of the ft_stopword_file, the search returned no results as it should. This has somehow turned into a big heary deal and they want the ft_stopword_file variable set to nothing so ALL words are included in a full text search.

I don't want to do this without knowing exactly what all those words are. Does anyone know how I can get a list of these words? The contents of the MySQL varibale is '(built-in)'...

So on with the questions:

  1. Can I view this list?
  2. Can I hand edit the list without rebuilding the entire list?

Any info on this would be great. Thanks.

    It probably is a table in your database. Do you have acces to the main database control? e.g. phpmyadmin, or an SQL connect window? THen look at the tables, and check the tables which look promising.

    It could be a file, but you have to search your system.

    The other way to find out is look at the source-code of the search function, and see where the match is made against. But since we did not build your site, we do not know where to look!

      I have full access to the system. I designed the database and wrote the search function and the ft_stopword_file is not set there. It's a global MySQL variable.

      Basic information on the variable can be found in the MySQL Manual section 12.7.4 Fine-Tuning MySQL Full-Text Search. This section says the actual ft_stopword_file variable will either be set to a file path (which would be great!) or direct MySQL to an interal list, mine is directing to an internal list.

      I know I can create a new file, change the variable to the new file path, and rebuild my index. But I wouldn't know what words I'm missing in my new list. So I guess my biggest concern at this point is seeing the current stopword list, which is now an internal part of MySQL...?

        Write a Reply...