Dazz Posted August 31, 2022 Posted August 31, 2022 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?
Solution Marc Posted August 31, 2022 Solution Posted August 31, 2022 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
Recommended Posts