Search a sub-field on MongoDB?

To search a sub-filed in MongoDB, you can use double quotes along with dot notation. Let us first create a collection with documents −

> db.searchSubFieldDemo.insertOne(
...   {
...      "UserDetails":
...      {"UserEmailId":"John123@gmail.com","UserAge":21}
...   }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3d909edc6604c74817ce2")
}
> db.searchSubFieldDemo.insertOne( { "UserDetails": {"UserEmailId":"Carol@yahoo.com","UserAge":26} } );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5cd3d9a4edc6604c74817ce3")
}

Following is the query to display all documents from a collection with the help of find() method −

> db.searchSubFieldDemo.find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5cd3d909edc6604c74817ce2"),
   "UserDetails" : {
      "UserEmailId" : "John123@gmail.com",
      "UserAge" : 21
   }
}
{
   "_id" : ObjectId("5cd3d9a4edc6604c74817ce3"),
   "UserDetails" : {
      "UserEmailId" : "Carol@yahoo.com",
      "UserAge" : 26
   }
}

Following is the query to search a sub-field on MongoDB −

> db.searchSubFieldDemo.find({"UserDetails.UserEmailId":"Carol@yahoo.com"});

This will produce the following output −

{ "_id" : ObjectId("5cd3d9a4edc6604c74817ce3"), "UserDetails" : { "UserEmailId" : "Carol@yahoo.com", "UserAge" : 26 } }

Smita Kapse

Updated on 30-Jul-2019 22:30:26

• Related Questions & Answers
• MongoDB query by sub-field?
• Sum MongoDB Sub-documents field?
• Search by specific field in MongoDB
• How to sum every field in a sub document of MongoDB?
• How to add an extra field in a sub document in MongoDB?
• Creating an index on a nested MongoDB field?
• MongoDB Regex Search on Integer Value?
• MongoDB find() to operate on recursive search?
• How to search for string or number in a field with MongoDB?
• How to get distinct list of sub-document field values in MongoDB?
• How to search for a record (field) and then delete it in MongoDB?
• How to query on list field in MongoDB?
• Conditional update depending on field matched in MongoDB
• How to fire find query on sub-documents in MongoDB?
• Filter sub documents by sub document in MongoDB?