How I query array type via Mongodb

Question

I have a document with property is an array like:

{
  name: ['Clark', 'Memphe', 'Alberto', 'Traicl']
}

I want query with keyword = 'cl' and I purpose the return will be

['Clark', 'Traicl']

How I can query with this conditions?

score 2 · Accepted Answer · answered Oct 12 '15 at 06:54

2

Try this query

db.collection.find({"name": /.*cl.*/})

answered Oct 12 '15 at 06:54

Rolwin Crasta

4,219
3
35
45

1

Tks bro. Im not sure it is too simple. I think the query need some operations like "$or" and "$like". Tkz u again! – Thanh Dao Oct 12 '15 at 07:03
You could refer : http://stackoverflow.com/questions/3305561/how-to-query-mongodb-with-like – Rolwin Crasta Oct 12 '15 at 07:12
3

This would be case sensitive. An `i` after the regex should make this case insensitive – Markus W Mahlberg Oct 12 '15 at 07:13

score 1 · Answer 2 · answered Oct 12 '15 at 07:55

One approach you can take is to use the aggregation framework. The aggregation pipeline would have the initial step $match that filters the documents with the name array that matches the regex pattern. Further down the pipeline you would need an $unwind operator which essentially turns one document into many. Another $match pipeline stage would be necessary to filter those deconstructed array documents and then a final $group step to aggregate the matched documents through the $push accumulator operator. So the following pipeline operation:

var re = new RegExp(/.*cl.*/i)
db.collection.aggregate([
    {
        "$match": { "name":  re }
    },
    {
        "$unwind": "$name"
    },
    {
        "$match": { "name": re }
    },
    {
        "$group": {
            "_id": null,
            "name": {
                "$push": "$name"
            }
        }
    }
])

will give the result:

{ "_id" : null, "name" : [ "Clark", "Traicl" ] }

How I query array type via Mongodb

2 Answers2