php - MySQL Search Query - "Keep" not working -
I am a bit confused with follow-up queries that I have been using for some time, the following tasks
" Fire Product "by Product Name (Product '' Fire '' in Boolean Mode) by the name of the product related to the search query
LIMIT 5 Return Fire Storage 31020 S1E Fire Storage 31020 S1 Fire Storage 31021 S 1E Fire Storage 31021 S1 Fire Storage 31022 S 1E
However, the query for the "Keep" query
Product related to the product - select Wikipedia against the product (the product) in 'Keep' * in Boolean mode * 5) No return results Although we have products in the table like "Fire door keep shut sign", "clean sign"
The only such word that I have found so far
"search"> is a stop-word
:
Compass Ting, words to stop the words that are filtered before processing the data of natural language or text (). [...] Certain tools avoid specifically excluding them to support phrase search, any group of words can be chosen as a stop word for a given purpose. For some search engines, these are some of the most common, short ceremony words, such as, but, who, and on. In this case, problems can be created during closing of words, in which those phrases can be searched, especially those names such as 'The Who', 'The D', or 'Take Le' are other search engines. Add words to some words, like "want" from the query to make it better than "want".
< P> You can find the list of actually used in the storage / Myisam / ft_static.c file.
Has been said in this fact
You may want to use Lucene instead of the stop-list is too small, you can remove them completely:
Or you can add
ft_stopword_file = "" or empty file "empty_stopwords.txt" in your .cnf / my.ini file, restart mysql engine Do and recreate the index:
I additionally, if you lose <3p>
Bdon (3, 2) less queries will grow dramatically in time, especially if the full text indexed column fields are large.
Comments
Post a Comment