GameTZ

Sign OnNon-Mobile

Search only does full words?
14-Mar-23 3:08pm
#1
John
GameTZ Gold Subscriber GameTZ Full Moderator 450 Trade Quintuple Gold Good Trader Gold Global Trader (13)

This may be "by design", but just wanted to mention it just in case...

I used the forum search to try to find the closed "Let's talk snacks" thread. I put in "snack" and searched subjects in General -- and found no matches. I changed it to "snacks" later and found it fine. I felt like "snack" should have found it.

But, again, if you are doing that on purpose, then not a big deal. 👍
14-Mar-23 3:20pm
#2
bill
GameTZ Gold Subscriber GameTZ Full Moderator 600 Trade Quintuple Gold Good Trader Has Written 28 Reviews

It has been a while since I looked at this, but from memory, this is more-or-less how it works. I'm using MySQL's fulltext search feature which matches words. It's very fast, so that's really helpful, but it has these cases like this that are not great. If I have it search by any string, it's much slower, so slow in some cases that it can wedge the site.

It's probably more complicated than that. The same is true for game searches as well. Also, it does support some quoting and such, so maybe there's a sneaky way to do it (but I'm forgetting it offhand).

It has been like this for many years, not something new. Though, there's some chance that moving to UTF-8 characters could affect this.
14-Mar-23 3:42pm
#3
Scott
GameTZ Subscriber Global Trader - willing to trade internationally Has Written 2 Reviews

Yeah, it's been like this as far back as I can remember.
14-Mar-23 3:49pm
#4
bill
GameTZ Gold Subscriber GameTZ Full Moderator 600 Trade Quintuple Gold Good Trader Has Written 28 Reviews

I did some searches to see if there was some way to prod MySQL into matching plural forms, but I didn't have much luck.
14-Mar-23 3:51pm
#5
bill
GameTZ Gold Subscriber GameTZ Full Moderator 600 Trade Quintuple Gold Good Trader Has Written 28 Reviews

DuckDuckGo found it with just "snack" *shrug* https://duckduckgo.c...
14-Mar-23 5:50pm
#6
John
GameTZ Gold Subscriber GameTZ Full Moderator 450 Trade Quintuple Gold Good Trader Gold Global Trader (13)

Ok, thanks. No worries.
1-Apr-23 9:59am
#7
DrizzDrizzDrizz
Double Gold Good Trader Global Trader - willing to trade internationally Croatia

bill wrote:
DuckDuckGo found it with just "snack" *shrug* https://duckduckgo.c...
maybe because of the word snack in original post, while John searched subjects only?

Search only does full words?