CODEWITHSUNDEEP
arrayssearchmongodb
Stephen Belanger
Stephen Belanger

Reputation: 6361

mongodb find by multiple array items

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.

Upvotes: 129

Views: 111444

Answers (1)

user24359
user24359

Reputation:

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"] }});

Upvotes: 243

Related Questions