"Unrelated" results due to SOUNDS LIKE

marco-pm / zencart_instantsearch

Instant Search plugin for Zen Cart

GNU General Public License v3.0

2 stars 4 forks source link

"Unrelated" results due to SOUNDS LIKE #7

Closed torvista closed 2 years ago

torvista commented 2 years ago

In my particular case, I was getting a lot of seemingly incorrect results. This was due to this (LEFT(pd.products_name, LENGTH(:wordSearch:)) SOUNDS LIKE :wordSearch:)" . which I have removed for my purposes. Not a complaint, just thought I'd point it out if others look for info on this. Possible this could be an admin option?

marco-pm commented 2 years ago

Yeah, I think there are some use cases where that condition leads to unwanted results.