Mongodb regex embedded search

Question

I got these documents:

id
name
friendList
- id
- name

I need to search in php (mongodb) for a friend, so name in friendList. How can I do this?

friendList is an array of {id, name} objects?

milan
– milan

2012-01-16 18:28:18 +00:00
Commented Jan 16, 2012 at 18:28 — milan
– milan, Commented Jan 16, 2012 at 18:28

milan · Accepted Answer · 2012-01-17 11:36:13Z

3

In the shell you'd do it like this:

> db.people.find({ "friendList.name" : /Joe/})

UPDATE: a proof:

> db.person.insert({name : 'scatman', friendList : [ {name: 'joe'}, {name: 'nick'}  ]});
> db.person.findOne()
{
    "_id" : ObjectId("4f155cafef7b8b0317a8ad17"),
    "name" : "scatman",
    "friendList" : [
        {
            "name" : "joe"
        },
        {
            "name" : "nick"
        }
    ]
}
> db.person.findOne({"friendList.name" : /jo/})
{
    "_id" : ObjectId("4f155cafef7b8b0317a8ad17"),
    "name" : "scatman",
    "friendList" : [
        {
            "name" : "joe"
        },
        {
            "name" : "nick"
        }
    ]
}
>

edited Jan 17, 2012 at 11:36

answered Jan 16, 2012 at 18:37

milan

12.5k3 gold badges46 silver badges49 bronze badges

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

1 Comment

milan Over a year ago

then either there's a bug in mongodb you're using or there's a bug in your code, or there's no one who's got Joe for his friend :) This query works just fine in mongodb 2.0.1.

Collectives™ on Stack Overflow

Mongodb regex embedded search

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related