Query.search issue - Parts of the search term are also found

Hey 🙂

I use this method to create a query array:

      let querys: string[] = [];
      combinations.forEach(combination => {
        querys.push(Query.search('ingredientNames', combination.nameNormalized).toString());
      });

Search word is e.g. bohnen_(weiss) . => "search("ingredientNames", ["bohnen_(weiss)"])"
There is also an underscore between bohnen and (weiss) that cannot be displayed here.
But entries with "pfefferkoerner_(weiss)" are also found...

That doesn't make any sense to me. 🤔

Any Idea ?

thanks

Hm, okay. It seems that no special characters or spaces can be used with the ".search" method, otherwise it will separate and search for both?

@VincentGe can you take a look at this?

I believe special characters are not searchable in MariaDB fulltext indexes

https://stackoverflow.com/questions/75296013/how-to-search-special-characters-in-fulltext-index-mysql

This might be related

You may have to be creative with your indexes for searching 😛

thanks 🙂 I dont use special characters anymore and it worked fine.