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

You can use the below-mentioned code for  that:-

db.things.find({ 

$or : [ {"first_name": "john"}, 

{"last_name": "john"} 

], 

"phone": "12345678" 

})

Answer 2

You are trying to run the query in the older version of MongoDB. The $and operator works with MongoDB v2.0+ versions. 

For using $and/$or operator, refer to the following code:

     db.getCollection('tbl_menu_items').find({

        $and : [

            { $or : [ { price : 0.99 }, { price : 1.99 } ] },

            { $or : [ { sale : true }, { qty : { $lt : 20 } } ] }

        ]

    } )