search
HomeDatabaseMongoDBHow to get all documents in an array that contain another document using MongoDB?

如何使用 MongoDB 获取数组中包含另一个文档的所有文档?

To do this, just use dot notation and find() in MongoDB. Let us create a collection containing documents -

> db.demo465.insertOne(
... {
...    id: 101,
...    details: [{
...       Name: "Chris",
...       Info: {
...          Subject: "MongoDB",
...          Marks:67
...       }
...    }, {
...          Name: "David",
...          Info: {
...             Subject: "MySQL",
...             Marks:78
...       }
...    }]
... }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e80421bb0f3fa88e2279061")
}
>
> db.demo465.insertOne(
... {
...    id: 102,
...    details: [{
...       Name: "Bob",
...       Info: {
...          Subject: "Java",
...          Marks:45
...       }
...    }, {
...          Name: "Carol",
...          Info: {
...             Subject: "C",
...             Marks:67
...          }
...       }]
...    }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e80421cb0f3fa88e2279062")
}

Display all the documents in the collection with the help of find() method-

> db.demo465.find();

This will produce the following output-

{ "_id" : ObjectId("5e80421bb0f3fa88e2279061"), "id" : 101, "details" : [ { "Name" : "Chris",
"Info" : { "Subject" : "MongoDB", "Marks" : 67 } }, { "Name" : "David", "Info" : { "Subject" :
"MySQL", "Marks" : 78 } } ] }
{ "_id" : ObjectId("5e80421cb0f3fa88e2279062"), "id" : 102, "details" : [ { "Name" : "Bob",
"Info" : { "Subject" : "Java", "Marks" : 45 } }, { "Name" : "Carol", "Info" : { "Subject" : "C",
"Marks" : 67 } } ] }

The following is Query to get all documents in an array that contain another document -

> db.demo465.find({"details.Name":"Bob"});

This will produce the following output -

{ "_id" : ObjectId("5e80421cb0f3fa88e2279062"), "id" : 102, "details" : [ { "Name" : "Bob",
"Info" : { "Subject" : "Java", "Marks" : 45 } }, { "Name" : "Carol", "Info" : { "Subject" : "C",
"Marks" : 67 } } ] }

The above is the detailed content of How to get all documents in an array that contain another document using MongoDB?. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:tutorialspoint. If there is any infringement, please contact admin@php.cn delete
MongoDB's Purpose: Flexible Data Storage and ManagementMongoDB's Purpose: Flexible Data Storage and ManagementMay 09, 2025 am 12:20 AM

MongoDB's flexibility is reflected in: 1) able to store data in any structure, 2) use BSON format, and 3) support complex query and aggregation operations. This flexibility makes it perform well when dealing with variable data structures and is a powerful tool for modern application development.

MongoDB vs. Oracle: Licensing, Features, and BenefitsMongoDB vs. Oracle: Licensing, Features, and BenefitsMay 08, 2025 am 12:18 AM

MongoDB is suitable for processing large-scale unstructured data and adopts an open source license; Oracle is suitable for complex commercial transactions and adopts a commercial license. 1.MongoDB provides flexible document models and scalability across the board, suitable for big data processing. 2. Oracle provides powerful ACID transaction support and enterprise-level capabilities, suitable for complex analytical workloads. Data type, budget and technical resources need to be considered when choosing.

MongoDB vs. Oracle: Exploring NoSQL and Relational ApproachesMongoDB vs. Oracle: Exploring NoSQL and Relational ApproachesMay 07, 2025 am 12:02 AM

In different application scenarios, choosing MongoDB or Oracle depends on specific needs: 1) If you need to process a large amount of unstructured data and do not have high requirements for data consistency, choose MongoDB; 2) If you need strict data consistency and complex queries, choose Oracle.

The Truth About MongoDB's Current SituationThe Truth About MongoDB's Current SituationMay 06, 2025 am 12:10 AM

MongoDB's current performance depends on the specific usage scenario and requirements. 1) In e-commerce platforms, MongoDB is suitable for storing product information and user data, but may face consistency problems when processing orders. 2) In the content management system, MongoDB is convenient for storing articles and comments, but it requires sharding technology when processing large amounts of data.

MongoDB vs. Oracle: Document Databases vs. Relational DatabasesMongoDB vs. Oracle: Document Databases vs. Relational DatabasesMay 05, 2025 am 12:04 AM

Introduction In the modern world of data management, choosing the right database system is crucial for any project. We often face a choice: should we choose a document-based database like MongoDB, or a relational database like Oracle? Today I will take you into the depth of the differences between MongoDB and Oracle, help you understand their pros and cons, and share my experience using them in real projects. This article will take you to start with basic knowledge and gradually deepen the core features, usage scenarios and performance performance of these two types of databases. Whether you are a new data manager or an experienced database administrator, after reading this article, you will be on how to choose and use MongoDB or Ora in your project

What's Happening with MongoDB? Exploring the FactsWhat's Happening with MongoDB? Exploring the FactsMay 04, 2025 am 12:15 AM

MongoDB is still a powerful database solution. 1) It is known for its flexibility and scalability and is suitable for storing complex data structures. 2) Through reasonable indexing and query optimization, its performance can be improved. 3) Using aggregation framework and sharding technology, MongoDB applications can be further optimized and extended.

Is MongoDB Doomed? Dispelling the MythsIs MongoDB Doomed? Dispelling the MythsMay 03, 2025 am 12:06 AM

MongoDB is not destined to decline. 1) Its advantage lies in its flexibility and scalability, which is suitable for processing complex data structures and large-scale data. 2) Disadvantages include high memory usage and late introduction of ACID transaction support. 3) Despite doubts about performance and transaction support, MongoDB is still a powerful database solution driven by technological improvements and market demand.

The Future of MongoDB: A Look at its ProspectsThe Future of MongoDB: A Look at its ProspectsMay 02, 2025 am 12:08 AM

MongoDB'sfutureispromisingwithgrowthincloudintegration,real-timedataprocessing,andAI/MLapplications,thoughitfaceschallengesincompetition,performance,security,andeaseofuse.1)CloudintegrationviaMongoDBAtlaswillseeenhancementslikeserverlessinstancesandm

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools