Dazz Posted August 31, 2022 Share 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? Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted August 31, 2022 Solution Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts