Noise words full text - logic behind

advertisements

As the title depicts, what is the logic behind implementing noise words in fulltext searches to avoid these words being searched? I mean, what if someone searches "to be or not to be"? No result shown? I'll highly appreciate if someone can tell me the logic behind, since I'm about to disable the ft_stopword_file.


If you disable the stop words then the performance will decrease dramatically. The workaround for this is to either check in your php code to see whether the stop words are in common in the search query and adapt a 'LIKE' search for those queries, or simply use sphinx as a search engine. The logic behind the stop words is to disable searching words like 'is,are,be,there,not' etc etc...