Dazz Posted March 2, 2022 Share Posted March 2, 2022 Hello, One of my users has reported issues with searching on my site. User is searching for the term doctor who. I tested out several different search combinations and results are very strange sometimes. Why would some of these searches return 0 results or expected results to not be found? Below are a couple tests that I ran using the same search for Doctor Who.Search for Lower case doctor who. This search temr returns 0 results. When actually there are close to 30. Search "Doctor Who" with quotes and proper capitilization, returns no results. Search "doctor who" in quotes in lower case, returns results. Search for Who* or who* using wildcard, returns 547 results. However, NONE of the results return "Doctor Who". Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted March 2, 2022 Solution Share Posted March 2, 2022 By default mysql will only search on 4 or more characters unless the mysql configuration is changed to allow fulltext search on lower numbers. Are you seeing it on other items whereby its less? Link to comment Share on other sites More sharing options...
Dazz Posted March 3, 2022 Author Share Posted March 3, 2022 23 hours ago, Marc Stridgen said: By default mysql will only search on 4 or more characters unless the mysql configuration is changed to allow fulltext search on lower numbers. Are you seeing it on other items whereby its less? Thanks, Marc. That explains the strange behaviour. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 3, 2022 Share Posted March 3, 2022 No problem at all. If you wish to change that, you can contact your hosting provider to see if they can amend that Link to comment Share on other sites More sharing options...
Recommended Posts