Mongodb AND Operation - MongoDB Tutorial




Mongodb AND Operation

  • In the find() method if we pass multiple keys by separating them by ',' then MongoDB treats it as AND condition.

Syntax :

db.collection.find({key1:value1, key2:value2}).pretty() 

Sample Query :

> db.wikitechy4.find({"author":"jln"}).pretty()
{
        "_id" : ObjectId("5731e2eadaa4a0bc932a2ffb"),
        "websitename" : "www.wikitechy.com",
        "details" : "next row inserted",
        "articlecount" : "40",
        "author" : "jln"
}
{
        "_id" : ObjectId("5731f734daa4a0bc932a2ffd"),
        "websitename" : "www.wikitechy.com",
        "details" : "last row inserted",
        "articlecount" : "40",
        "author" : "jln"
}
{
        "_id" : ObjectId("5731f73fdaa4a0bc932a2ffe"),
        "websitename" : "www.wikitechy.com",
        "details" : "last row inserted",
        "articlecount" : "50",
        "author" : "jln"
}
> db.wikitechy4.find({"author":"jln","articlecount":"50"}).pretty()
{
        "_id" : ObjectId("5731f73fdaa4a0bc932a2ffe"),
        "websitename" : "www.wikitechy.com",
        "details" : "last row inserted",
        "articlecount" : "50",
        "author" : "jln"
}
>

MongoDb


Output

MongoDb
  1. Here in this output, we display the 3 rows of data’s from the collection “wikitechy4” where only the author name as “jln” tends to display that data using find() rich query.
  2. Over here in this output, we display the data from the collection “wikitechy4” where only the author name as “jln” & the article count as “50” constrain data’s will be displayed using find() rich query.


Related Searches to Mongodb and operation - MongoDB Tutorial

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×