mongodb find by multiple array items

arrays search mongodb
Stephen Belanger picture Stephen Belanger · Nov 16, 2011 · Viewed 68.2k times · Source

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.

Answer

user24359 picture user24359 · Nov 16, 2011

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

Related questions

Using C# to check if string contains a string in string array

I want to use C# to check if a string value contains a word in a string array. For example, string stringToCheck = "text1text2text3"; string[] stringArray = { "text1", "someothertext", etc... }; if(stringToCheck.contains stringArray) //one of the items? { } How can …

Read More
How to find the index of an element in an int array?

How can I find an index of a certain value in a Java array of type int? I tried using Arrays.binarySearch on my unsorted array, it only sometimes gives the correct answer.

Read More
How to search by key=>value in a multidimensional array in PHP

Is there any fast way to get all subarrays where a key value pair was found in a multidimensional array? I can't say how deep the array will be. Simple example array: $arr = array(0 => array(id=>1,name=>"…

Read More