How to query MongoDB for matching documents where item is in document array

Question

If my stored document looks like this:

doc = {
    'Things' : [ 'one' , 'two' , 'three' ]
    }

How can I query for documents which contain one in Things?

I know the $in operator queries a document item against a list, but this is kind of the reverse. Any help would be awesome.

mu is too short · Accepted Answer · 2012-10-05 04:23:40Z

2

Use MongoDB's multikeys support:

MongoDB provides an interesting "multikey" feature that can automatically index arrays of an object's values.
[...]
db.articles.find( { tags: 'april' } )
{"name" : "Warm Weather" , "author" : "Steve" , 
 "tags" : ["weather","hot","record","april"] , 
 "_id"  : "497ce4051ca9ca6d3efca323"}

Basically, you don't have to worry about the array-ness of Things, MongoDB will take care of that for you; something like this in the MongoDB shell would work:

db.your_collection.find({ Things: 'one' })

answered Oct 5, 2012 at 4:23

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query MongoDB for matching documents where item is in document array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related