Can anyone help me with the partial text search in mongodb Atlas using text.
for example : user search for text ‘add’ it should return ‘addidas’, ‘addition’ etc
You can solve this with an autocomplete index definition on the field and a query with the autocomplete operator for maximum speed.
Otherwise, you can use the keyword analyzer and the regex operator.
Yes I can resolve this by using autocomplete but I don’t want to and facing issue while using regex as it only matches keyword not partial word.
with regex you can achieve this with a trailing wildcard character, as in add*. That should work.
I have tried that but for matching the exact statement it fails the return result