Search with AND operator in MongoDB using $text query operator

Question

I already have text index in MongoDB.

Simple search:

db.news.find({ $text: { $search: "covid" } })

I get all the articles containing covid in the text.

Now I want to get all the articles that contain both covid and vaccination.

This query for example...

db.news.find({ $text: { $search: "\"covid vaccination\"" } })

...will only find articles that contain "covid vaccination" side by side, in that order. In other words, article structured like this: "Vaccination against covid..." will not be found.

I want to find all articles where covid and vaccination are included in the article, regardless of each word position, using the text index. Any ideas?

Maxim Sharai · Answer 1 · 2021-11-29T20:54:36.513

1

I re-checked MongoDB documentation and didn't find the way how to do it. May be this will help:

db.news.find({$text: {$search: "covid vaccination"}}).sort({score: {$meta: "textScore"}})

It wouldn't get the required result, but, at least, the result will sorted by score. The records which contains the both "covid" and "vaccination" should be at the top

edited Nov 29 '21 at 20:54

answered Nov 25 '21 at 22:11

Maxim Sharai

604
3
11

1

It functions like there is an OR operator between the words. I get all the covid articles and all the vaccination articles. – Pétur Haukur Jóhannesson Nov 29 '21 at 13:18
1

Sorry, my fault. I updated my comment to, at least, try to help you to find a solution – Maxim Sharai Nov 29 '21 at 20:55
One step closer to the end goal. Thank you :) – Pétur Haukur Jóhannesson Dec 03 '21 at 09:37

Search with AND operator in MongoDB using $text query operator

1 Answers1