Mysql Fulltext not showing results for particular keywords

Avatar
  • Answered
When i search "Cometh the hour" it returns results but "me before you" returns none. the keyword is present in the table but it not listed by fulltext search. I'm worried whether its because of stopwords and how to overcome this issue?
Avatar
Arn
Hello, Thanks for the question about the stopwords when doing a MySQL Fulltext search. I looked around on this issue and as you may (or may not) be aware, the stopwords are used because they include many common words that may otherwise result in having large indices. In several articles, I read that you could edit the stopwords list. Here's an example of the response that I've been finding: MySQL Fulltext Stopwords Rationale. I hope that helps to answer your question. If you're not familiar with editing the stopwords list, then you may need to consult with a developer/programmer to resolve the issue. If you have any further questions or comments, please let us know. Regards, Arnel C.