Match ID and fetch documents with $eq in MongoDB in case of array?

Use $eq operator along with find() to match ID and fetch documents. The $eq specifies equality condition. It matches documents where the value of a field equals the specified value.

Let us create a collection with documents −

> db.demo426.insert({"Ids":["110","120","101"]});
WriteResult({ "nInserted" : 1 })
> db.demo426.insert({"Ids":["100","201","401"]});
WriteResult({ "nInserted" : 1 })
> db.demo426.insert({"Ids":["501","600","700"]});
WriteResult({ "nInserted" : 1 })

Display all documents from a collection with the help of find() method −

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

This will produce the following output −

{
   "_id" : ObjectId("5e75e50fbbc41e36cc3cae72"),
   "Ids" : [
         "110",
         "120",
         "101"
      ]
   }
{
   "_id" : ObjectId("5e75e51abbc41e36cc3cae73"),
   "Ids" : [
      "100",
      "201",
      "401"
      ]
   }
   {
   "_id" : ObjectId("5e75e527bbc41e36cc3cae74"),
   "Ids" : [
      "501",
      "600",
      "700"
   ]
}

Following is the query match ID with $eq in MongoDB −

> db.demo426.find({"Ids":{$eq:"501"}});

This will produce the following output −

{ "_id" : ObjectId("5e75e527bbc41e36cc3cae74"), "Ids" : [ "501", "600", "700" ] }

AmitDiwan

Published on 03-Apr-2020 13:56:52

• Related Questions & Answers
• Match MongoDB documents with field value greater than a specific number and fetch them?
• Match MongoDB documents with fields not containing values in array?
• MongoDB to fetch documents with $or Operator
• Fetch specific multiple documents in MongoDB
• Fetch multiple documents in MongoDB query with OR condition?
• Fetch specific documents with array values in MongoD
• Fetch all the ids of MongoDB documents?
• MongoDB compound conditions to fetch documents?
• MongoDB aggregation to fetch documents with specific field value?
• MongoDB query to match documents that contain an array field
• Match element in array of MongoDB?
• MongoDB query to match documents with array values greater than a specific value
• Find in MongoDB documents with filled nested array and reshape the documents result
• MongoDB query to display documents with a specific name irrespective of case
• Implement array match in MongoDB?