Jump to content

Featured Replies

Posted

I have users stating when they search for specific terms the site is not returning results.

The most common seems to be the word "from".
Could contain: Text

Removing "from" from the search returns
Could contain: Text, Page

Earlier we were experiencing the same issue with the word "zone".

I know searching for 3 character words is an SQL setting, but why would search not be returning results with other specifc words?

Solved by Marc

Go to solution
  • Solution

There re indeed. There are mysql stop words which would not be searchable with mysql fulltext. You can see more about this here. (of course this is mysql 8 so you may have to look up for your version)

https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html

Using INNODB will ensure you have the shortest list of those

Recently Browsing 0

  • No registered users viewing this page.