mongodb find by multiple array items

ArraysSearchMongodb

Arrays Problem Overview


If I have a record like this;

{
  "text": "text goes here",
  "words": ["text", "goes", "here"]
}

How can I match multiple words from it in MongoDB? When matching a single word I can do this;

db.find({ words: "text" })

But when I try this for multiple words, it doesn't work;

db.find({ words: ["text", "here"] })

I'm guessing that by using an array, it tries to match the entire array against the one in the record, rather than matching the individual contents.

Arrays Solutions


Solution 1 - Arrays

Depends on whether you're trying to find documents where words contains both elements (text and here) using $all:

db.things.find({ words: { $all: ["text", "here"] }});

or either of them (text or here) using $in:

db.things.find({ words: { $in: ["text", "here"] }});

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionStephen BelangerView Question on Stackoverflow
Solution 1 - Arraysuser24359View Answer on Stackoverflow