August 31, 2022 in Technical Problems
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".
Removing "from" from the search returns
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?
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)
Using INNODB will ensure you have the shortest list of those
Started 1 hour ago
Started August 29
Started April 24, 2021