full text search not working for me

I'm using full text search on product name I have listed product name as this

Carpet Red 123
Dustbin Red 134
Carpet Blue 233

when I try to search for "Carpet Red", it works fine but when I search for "Red Carpet" it doesn't show the product. How do I achieve this result??

TL;DR

The user is experiencing an issue with their full text search. When searching for "Red Carpet", the results are empty, but when searching for "Carpet Red", the product is shown. The user is using Flutter/Dart and their query looks like this: `Query.search("name", search)`. The issue might be related to the order of the words or the use of quotes. The solution might be to wrap the search phrase in double quotes, like `"Red Carpet"`, and make sure the order of the words matches the product name.

Are you wrapping with double quotes? If you are, then the order matters

Otherwise... It could be because it's actually searching for word starting with carpet...

i haven't wrapped it in double or single quotes but i have it on the lowercase

does it matter?

Query.search("name", search), My query looks like this where search is string when I get this in console search("name", ["red carpet"]) It shows like this.

How should I complete it?

BTW i'm using flutter/dart

In that case...I think it's because we add a wildcard at the end of the search. Try searching for carpe and compare with carpet

Red is probably ignored because it's too short

If I search for carpet it shows

both gives me empty array

do you mean carpe?

you mean "red carpet" gives empty array?

yea....

Reply to this thread by joining our Discord

Reply on Discord