mongodb queries both with AND and OR

Question

can I use combination of OR and AND in mongodb queries?

the code below doesn't work as expected

db.things.find({            $and:[                 {$or:[                      {"first_name" : "john"},                       {"last_name" : "john"}                 ]},                 {"phone": "12345678"}             ]}); 

database content:

> db.things.find(); { "_id" : ObjectId("4fe8734ac27bc8be56947d60"), "first_name" : "john", "last_name" : "hersh", "phone" : "2222" } { "_id" : ObjectId("4fe8736dc27bc8be56947d61"), "first_name" : "john", "last_name" : "hersh", "phone" : "12345678" } { "_id" : ObjectId("4fe8737ec27bc8be56947d62"), "first_name" : "elton", "last_name" : "john", "phone" : "12345678" } { "_id" : ObjectId("4fe8738ac27bc8be56947d63"), "first_name" : "eltonush", "last_name" : "john", "phone" : "5555" } 

when querying the above query - i get nothing!

> db.things.find({$and:[{$or:[{"first_name" : "john"}, {"last_name" : "john"}]},{"phone": "12345678"}]}); > 

I'm using mongo 1.8.3

Answer 1

 db.things.find( {       $and : [                {                   $or : [                           {"first_name" : "john"},                          {"last_name" : "john"}                        ]                },                {                   "Phone":"12345678"                }              ]     } ) 

AND takes an array of 2 expressions OR , phone.
OR takes an array of 2 expressions first_name , last_name.

AND

• OR

  • first_name
  • last_name

• Phone Number.

Note: Upgrade to latest version of MongoDB, if this doesn't work.

Answer 2

Shorter to use an implicit AND operation:

db.things.find({     $or : [          {"first_name": "john"},         {"last_name": "john"}     ],     "phone": "12345678"          })