> For the complete MongoDB documentation index, see www.mongodb.com/docs/llms.txt # Read Documents In MongoDB, a Read operation consists of querying the database. This page provides examples. You can query documents in MongoDB with the following methods: - Your programming language's driver. - The [MongoDB Atlas UI](https://www.mongodb.com/docs/atlas/). To learn more, see [Query for Null or Missing Fields with MongoDB Atlas](https://www.mongodb.com/docs/manual/tutorial/query-for-null-fields.md#std-label-query-null-documents-atlas-ui). - [MongoDB Compass.](https://www.mongodb.com/docs/compass/current/) **Tip:** You can use a large language model to generate your queries for you. To learn more, see [Natural Language to MongoDB Queries.](https://www.mongodb.com/docs/manual/natural-language-to-mongodb.md#std-label-natural-language-to-mongodb) This page provides examples of query operations using the [`db.collection.find()`](https://www.mongodb.com/docs/manual/reference/method/db.collection.find.md#mongodb-method-db.collection.find) method in [`mongosh`.](https://www.mongodb.com/docs/mongodb-shell.md#mongodb-binary-bin.mongosh) This page provides examples of query operations using [mongoc\_collection\_find\_with\_opts.](https://mongoc.org/libmongoc/current/mongoc_collection_find_with_opts.html) The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using [MongoDB Compass.](https://www.mongodb.com/docs/compass/current.md#std-label-compass-index) The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [`pymongo.collection.Collection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find) method in the [PyMongo](https://www.mongodb.com/docs/languages/python/pymongo-driver/current/) Python driver. The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: As of May 14, 2025, Motor is deprecated in favor of the GA release of the PyMongo Async API in the PyMongo library. We will not add new features to Motor, and we will provide only bug fixes until it reaches end of life on May 14, 2026. After that, we will fix only critical bugs until final support ends on May 14, 2027. We strongly recommend migrating to the PyMongo Async API while Motor is still supported. For more information about migrating, see the [Migrate to PyMongo Async](https://www.mongodb.com/docs/languages/python/pymongo-driver/reference/migration.md#std-label-pymongo-async-motor-migration) guide in the PyMongo documentation. This page provides examples of query operations using the [`pymongo.asynchronous.collection.AsyncCollection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find) method in the [PyMongo Async API](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/index.html). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [com.mongodb.client.MongoCollection.find](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/MongoCollection.html#find--) method in the MongoDB [Java Synchronous Driver.](http://mongodb.github.io/mongo-java-driver/3.4/driver/) **Tip:** The driver provides [com.mongodb.client.model.Filters](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/model/Filters.html) helper methods to facilitate the creation of filter documents. The examples on this page use these methods to create the filter documents. The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [com.mongodb.reactivestreams.client.MongoCollection.find](http://mongodb.github.io/mongo-java-driver-reactivestreams/1.6/javadoc/com/mongodb/reactivestreams/client/MongoCollection.html#find\(\)) method in the MongoDB [Java Reactive Streams Driver](http://mongodb.github.io/mongo-java-driver-reactivestreams/1.6/). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations by using the [MongoCollection.find()](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-kotlin-coroutine/mongodb-driver-kotlin-coroutine/com.mongodb.kotlin.client.coroutine/-mongo-collection/find.html) method in the MongoDB [Kotlin Coroutine Driver.](https://www.mongodb.com/docs/drivers/kotlin/coroutine/current/) **Tip:** The driver provides [com.mongodb.client.model.Filters](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-core/com/mongodb/client/model/Filters.html) helper methods to facilitate the creation of filter documents. The examples on this page use these methods to create the filter documents. The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [Collection.find()](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#find) method in the [MongoDB Node.js Driver.](http://mongodb.github.io/node-mongodb-native/3.6/) The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [`MongoDB\\Collection::find()`](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-find.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--find--) method in the [MongoDB PHP Library](https://www.mongodb.com/docs/drivers/php-libraries/). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [Mongo::Collection#find()](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Collection.html#find-instance_method) method in the [MongoDB Ruby Driver.](https://www.mongodb.com/docs/ruby-driver/current/) The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [collection.find()](http://mongodb.github.io/mongo-scala-driver/2.9/scaladoc/org/mongodb/scala/MongoCollection.html#find[C]\(filter:org.mongodb.scala.bson.conversions.Bson\)\(implicite:org.mongodb.scala.bson.DefaultHelper.DefaultsTo[C,TResult],implicitct:scala.reflect.ClassTag[C]\):org.mongodb.scala.FindObservable[C]) method in the [MongoDB Scala Driver](http://mongodb.github.io/mongo-scala-driver/). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [MongoCollection.Find()](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_Find.htm) method in the [MongoDB .NET/C# Driver](https://mongodb.github.io/mongo-csharp-driver/). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: This page provides examples of query operations using the [Collection.Find](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Collection.Find) function in the [MongoDB Go Driver](https://github.com/mongodb/mongo-go-driver/). The examples on this page use the `inventory` collection. Connect to a test database in your MongoDB instance then create the `inventory` collection: The examples on this page use data from the [sample\_mflix dataset](https://www.mongodb.com/docs/manual/sample-data/sample-mflix.md#std-label-sample-mflix). For details on how to load this dataset into your self-managed MongoDB deployment, see [Load the Sample Dataset](https://www.mongodb.com/docs/manual/sample-data/load-sample-data-local.md#std-label-sample-dataset-local). If you made any modifications to the sample databases, you may need to drop and recreate the databases to run the examples on this page. ```javascript [ { "item": "journal", "qty": 25, "size": { "h": 14, "w": 21, "uom": "cm" }, "status": "A" }, { "item": "notebook", "qty": 50, "size": { "h": 8.5, "w": 11, "uom": "in" }, "status": "A" }, { "item": "paper", "qty": 100, "size": { "h": 8.5, "w": 11, "uom": "in" }, "status": "D" }, { "item": "planner", "qty": 75, "size": { "h": 22.85, "w": 30, "uom": "cm" }, "status": "D" }, { "item": "postcard", "qty": 45, "size": { "h": 10, "w": 15.25, "uom": "cm" }, "status": "A" } ] ``` For instructions on inserting documents in MongoDB Compass, see [Insert Documents.](https://www.mongodb.com/docs/manual/tutorial/insert-documents.md#std-label-write-op-insert) ```c mongoc_collection_t *collection; mongoc_bulk_operation_t *bulk; bson_t *doc; bool r; bson_error_t error; bson_t reply; collection = mongoc_database_get_collection (db, "inventory"); bulk = mongoc_collection_create_bulk_operation_with_opts (collection, NULL); doc = BCON_NEW ( "item", BCON_UTF8 ("journal"), "qty", BCON_INT64 (25), "size", "{", "h", BCON_DOUBLE (14), "w", BCON_DOUBLE (21), "uom", BCON_UTF8 ("cm"), "}", "status", BCON_UTF8 ("A")); r = mongoc_bulk_operation_insert_with_opts (bulk, doc, NULL, &error); bson_destroy (doc); if (!r) { MONGOC_ERROR ("%s\n", error.message); goto done; } doc = BCON_NEW ( "item", BCON_UTF8 ("notebook"), "qty", BCON_INT64 (50), "size", "{", "h", BCON_DOUBLE (8.5), "w", BCON_DOUBLE (11), "uom", BCON_UTF8 ("in"), "}", "status", BCON_UTF8 ("A")); r = mongoc_bulk_operation_insert_with_opts (bulk, doc, NULL, &error); bson_destroy (doc); if (!r) { MONGOC_ERROR ("%s\n", error.message); goto done; } doc = BCON_NEW ( "item", BCON_UTF8 ("paper"), "qty", BCON_INT64 (100), "size", "{", "h", BCON_DOUBLE (8.5), "w", BCON_DOUBLE (11), "uom", BCON_UTF8 ("in"), "}", "status", BCON_UTF8 ("D")); r = mongoc_bulk_operation_insert_with_opts (bulk, doc, NULL, &error); bson_destroy (doc); if (!r) { MONGOC_ERROR ("%s\n", error.message); goto done; } doc = BCON_NEW ( "item", BCON_UTF8 ("planner"), "qty", BCON_INT64 (75), "size", "{", "h", BCON_DOUBLE (22.85), "w", BCON_DOUBLE (30), "uom", BCON_UTF8 ("cm"), "}", "status", BCON_UTF8 ("D")); r = mongoc_bulk_operation_insert_with_opts (bulk, doc, NULL, &error); bson_destroy (doc); if (!r) { MONGOC_ERROR ("%s\n", error.message); goto done; } doc = BCON_NEW ( "item", BCON_UTF8 ("postcard"), "qty", BCON_INT64 (45), "size", "{", "h", BCON_DOUBLE (10), "w", BCON_DOUBLE (15.25), "uom", BCON_UTF8 ("cm"), "}", "status", BCON_UTF8 ("A")); r = mongoc_bulk_operation_insert_with_opts (bulk, doc, NULL, &error); bson_destroy (doc); if (!r) { MONGOC_ERROR ("%s\n", error.message); goto done; } /* "reply" is initialized on success or error */ r = (bool) mongoc_bulk_operation_execute (bulk, &reply, &error); if (!r) { MONGOC_ERROR ("%s\n", error.message); } ``` ```python db.inventory.insert_many( [ { "item": "journal", "qty": 25, "size": {"h": 14, "w": 21, "uom": "cm"}, "status": "A", }, { "item": "notebook", "qty": 50, "size": {"h": 8.5, "w": 11, "uom": "in"}, "status": "A", }, { "item": "paper", "qty": 100, "size": {"h": 8.5, "w": 11, "uom": "in"}, "status": "D", }, { "item": "planner", "qty": 75, "size": {"h": 22.85, "w": 30, "uom": "cm"}, "status": "D", }, { "item": "postcard", "qty": 45, "size": {"h": 10, "w": 15.25, "uom": "cm"}, "status": "A", }, ] ) ``` ```python await db.inventory.insert_many( [ { "item": "journal", "qty": 25, "size": {"h": 14, "w": 21, "uom": "cm"}, "status": "A", }, { "item": "notebook", "qty": 50, "size": {"h": 8.5, "w": 11, "uom": "in"}, "status": "A", }, { "item": "paper", "qty": 100, "size": {"h": 8.5, "w": 11, "uom": "in"}, "status": "D", }, { "item": "planner", "qty": 75, "size": {"h": 22.85, "w": 30, "uom": "cm"}, "status": "D", }, { "item": "postcard", "qty": 45, "size": {"h": 10, "w": 15.25, "uom": "cm"}, "status": "A", }, ] ) ``` ```java collection.insertMany(asList( Document.parse("{ item: 'journal', qty: 25, size: { h: 14, w: 21, uom: 'cm' }, status: 'A' }"), Document.parse("{ item: 'notebook', qty: 50, size: { h: 8.5, w: 11, uom: 'in' }, status: 'A' }"), Document.parse("{ item: 'paper', qty: 100, size: { h: 8.5, w: 11, uom: 'in' }, status: 'D' }"), Document.parse("{ item: 'planner', qty: 75, size: { h: 22.85, w: 30, uom: 'cm' }, status: 'D' }"), Document.parse("{ item: 'postcard', qty: 45, size: { h: 10, w: 15.25, uom: 'cm' }, status: 'A' }") )); ``` ```java Publisher insertManyPublisher = collection.insertMany(asList( Document.parse("{ item: 'journal', qty: 25, size: { h: 14, w: 21, uom: 'cm' }, status: 'A' }"), Document.parse("{ item: 'notebook', qty: 50, size: { h: 8.5, w: 11, uom: 'in' }, status: 'A' }"), Document.parse("{ item: 'paper', qty: 100, size: { h: 8.5, w: 11, uom: 'in' }, status: 'D' }"), Document.parse("{ item: 'planner', qty: 75, size: { h: 22.85, w: 30, uom: 'cm' }, status: 'D' }"), Document.parse("{ item: 'postcard', qty: 45, size: { h: 10, w: 15.25, uom: 'cm' }, status: 'A' }") )); ``` ```kotlin collection.insertMany( listOf( Document("item", "journal") .append("qty", 25) .append("size", Document("h", 14) .append("w", 21) .append("uom", "cm") ) .append("status", "A"), Document("item", "notebook") .append("qty", 50) .append("size", Document("h", 8.5) .append("w", 11) .append("uom", "in") ) .append("status", "A"), Document("item", "paper") .append("qty", 100) .append("size", Document("h", 8.5) .append("w", 11) .append("uom", "in") ) .append("status", "D"), Document("item", "planner") .append("qty", 75) .append("size", Document("h", 22.85) .append("w", 30) .append("uom", "cm") ) .append("status", "D"), Document("item", "postcard") .append("qty", 45) .append("size", Document("h", 10) .append("w", 15.25) .append("uom", "cm") ) .append("status", "A"), ) ) ``` ```javascript await db.collection('inventory').insertMany([ { item: 'journal', qty: 25, size: { h: 14, w: 21, uom: 'cm' }, status: 'A' }, { item: 'notebook', qty: 50, size: { h: 8.5, w: 11, uom: 'in' }, status: 'A' }, { item: 'paper', qty: 100, size: { h: 8.5, w: 11, uom: 'in' }, status: 'D' }, { item: 'planner', qty: 75, size: { h: 22.85, w: 30, uom: 'cm' }, status: 'D' }, { item: 'postcard', qty: 45, size: { h: 10, w: 15.25, uom: 'cm' }, status: 'A' } ]); ``` ```php $insertManyResult = $db->inventory->insertMany([ [ 'item' => 'journal', 'qty' => 25, 'size' => ['h' => 14, 'w' => 21, 'uom' => 'cm'], 'status' => 'A', ], [ 'item' => 'notebook', 'qty' => 50, 'size' => ['h' => 8.5, 'w' => 11, 'uom' => 'in'], 'status' => 'A', ], [ 'item' => 'paper', 'qty' => 100, 'size' => ['h' => 8.5, 'w' => 11, 'uom' => 'in'], 'status' => 'D', ], [ 'item' => 'planner', 'qty' => 75, 'size' => ['h' => 22.85, 'w' => 30, 'uom' => 'cm'], 'status' => 'D', ], [ 'item' => 'postcard', 'qty' => 45, 'size' => ['h' => 10, 'w' => 15.25, 'uom' => 'cm'], 'status' => 'A', ], ]); ``` ```ruby client[:inventory].insert_many([ { item: 'journal', qty: 25, size: { h: 14, w: 21, uom: 'cm' }, status: 'A' }, { item: 'notebook', qty: 50, size: { h: 8.5, w: 11, uom: 'in' }, status: 'A' }, { item: 'paper', qty: 100, size: { h: 8.5, w: 11, uom: 'in' }, status: 'D' }, { item: 'planner', qty: 75, size: { h: 22.85, w: 30, uom: 'cm' }, status: 'D' }, { item: 'postcard', qty: 45, size: { h: 10, w: 15.25, uom: 'cm' }, status: 'A' } ]) ``` ```scala collection.insertMany(Seq( Document("""{ item: "journal", qty: 25, size: { h: 14, w: 21, uom: "cm" }, status: "A" }"""), Document("""{ item: "notebook", qty: 50, size: { h: 8.5, w: 11, uom: "in" }, status: "A" }"""), Document("""{ item: "paper", qty: 100, size: { h: 8.5, w: 11, uom: "in" }, status: "D" }"""), Document("""{ item: "planner", qty: 75, size: { h: 22.85, w: 30, uom: "cm" }, status: "D" }"""), Document("""{ item: "postcard", qty: 45, size: { h: 10, w: 15.25, uom: "cm" }, status: "A" }""") )).execute() ``` ```csharp var documents = new BsonDocument[] { new BsonDocument { { "item", "journal" }, { "qty", 25 }, { "size", new BsonDocument { { "h", 14 }, { "w", 21 }, { "uom", "cm"} } }, { "status", "A" } }, new BsonDocument { { "item", "notebook" }, { "qty", 50 }, { "size", new BsonDocument { { "h", 8.5 }, { "w", 11 }, { "uom", "in"} } }, { "status", "A" } }, new BsonDocument { { "item", "paper" }, { "qty", 100 }, { "size", new BsonDocument { { "h", 8.5 }, { "w", 11 }, { "uom", "in"} } }, { "status", "D" } }, new BsonDocument { { "item", "planner" }, { "qty", 75 }, { "size", new BsonDocument { { "h", 22.85 }, { "w", 30 }, { "uom", "cm"} } }, { "status", "D" } }, new BsonDocument { { "item", "postcard" }, { "qty", 45 }, { "size", new BsonDocument { { "h", 10 }, { "w", 15.25 }, { "uom", "cm"} } }, { "status", "A" } }, }; collection.InsertMany(documents); ``` ```go docs := []any{ bson.D{ {"item", "journal"}, {"qty", 25}, {"size", bson.D{ {"h", 14}, {"w", 21}, {"uom", "cm"}, }}, {"status", "A"}, }, bson.D{ {"item", "notebook"}, {"qty", 50}, {"size", bson.D{ {"h", 8.5}, {"w", 11}, {"uom", "in"}, }}, {"status", "A"}, }, bson.D{ {"item", "paper"}, {"qty", 100}, {"size", bson.D{ {"h", 8.5}, {"w", 11}, {"uom", "in"}, }}, {"status", "D"}, }, bson.D{ {"item", "planner"}, {"qty", 75}, {"size", bson.D{ {"h", 22.85}, {"w", 30}, {"uom", "cm"}, }}, {"status", "D"}, }, bson.D{ {"item", "postcard"}, {"qty", 45}, {"size", bson.D{ {"h", 10}, {"w", 15.25}, {"uom", "cm"}, }}, {"status", "A"}, }, } result, err := coll.InsertMany(context.TODO(), docs) ``` ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection ## Select All Documents in a Collection To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the [query bar](https://www.mongodb.com/docs/compass/current/query/filter.md#std-label-compass-query-bar). The [query filter parameter](https://www.mongodb.com/docs/compass/current/query/filter.md#std-label-compass-query-bar-filter) determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: To select all documents in the collection, pass an empty document as the query filter parameter to the find method. The query filter parameter determines the select criteria: ```javascript db.movies.find( {} ) ``` ![Compass select all documents in collection](/images/compass-select-all-new.png) ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW (NULL); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` Clean up any open resources by calling the following methods, as appropriate: - [bson\_destroy](http://mongoc.org/libbson/current/bson_destroy.html) - [mongoc\_bulk\_operation\_destroy](https://mongoc.org/libmongoc/current/mongoc_bulk_operation_destroy.html) - [mongoc\_collection\_destroy](https://mongoc.org/libmongoc/current/mongoc_collection_destroy) - [mongoc\_cursor\_destroy,](https://mongoc.org/libmongoc/current/mongoc_cursor_destroy.html) ```python cursor = db.inventory.find({}) ``` ```python cursor = db.inventory.find({}) ``` ```java FindIterable findIterable = collection.find(new Document()); ``` ```java FindPublisher findPublisher = collection.find(new Document()); ``` ```kotlin val flowInsertMany = collection .find(empty()) ``` ```javascript const cursor = db.collection('inventory').find({}); ``` ```php $cursor = $db->inventory->find([]); ``` ```ruby client[:inventory].find({}) ``` ```scala var findObservable = collection.find(Document()) ``` ```csharp var filter = Builders.Filter.Empty; var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{}, ) ``` This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: This operation uses an empty [query predicate](https://www.mongodb.com/docs/manual/reference/glossary.md#std-term-query-predicate) of `{}`, which corresponds to the following SQL statement: ```sql SELECT * FROM movies ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` ```sql SELECT * FROM inventory ``` For more information, see [`find()`.](https://www.mongodb.com/docs/manual/reference/method/db.collection.find.md#mongodb-method-db.collection.find) For more information, see [Query Bar.](https://www.mongodb.com/docs/compass/current/query/filter.md#std-label-compass-query-bar) For more information, see [mongoc\_collection\_find\_with\_opts.](https://mongoc.org/libmongoc/current/mongoc_collection_find_with_opts.html) For more information, see [`find`.](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find) For more information, see [`find`.](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find) For more information, see [com.mongodb.client.MongoCollection.find.](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/MongoCollection.html#find--) For more information, see [com.mongodb.reactivestreams.client.MongoCollection.find](http://mongodb.github.io/mongo-java-driver-reactivestreams/1.6/javadoc/com/mongodb/reactivestreams/client/MongoCollection.html#find\(\)). For more information, see [MongoCollection.find().](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-kotlin-coroutine/mongodb-driver-kotlin-coroutine/com.mongodb.kotlin.client.coroutine/-mongo-collection/find.html) For more information, see [find().](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#find) For more information, see [`find()`.](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-find.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--find--) For more information, see [find().](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Collection.html#find-instance_method) For more information, see [collection.find().](http://mongodb.github.io/mongo-scala-driver/2.9/scaladoc/org/mongodb/scala/MongoCollection.html#find[C]\(filter:org.mongodb.scala.bson.conversions.Bson\)\(implicite:org.mongodb.scala.bson.DefaultHelper.DefaultsTo[C,TResult],implicitct:scala.reflect.ClassTag[C]\):org.mongodb.scala.FindObservable[C]) For more information, see [Find().](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_Find.htm) For more information, see [Collection.Find.](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Collection.Find) ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition ## Specify Equality Condition To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```javascript { : , ... } ``` To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```javascript { : , ... } ``` To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```c { : , ... } ``` To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```python { : , ... } ``` To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```python { : , ... } ``` To specify equality conditions, use the `com.mongodb.client.model.Filters.eq_` method to create the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```java and(eq(, ), eq(, ) ...) ``` To specify equality conditions, use the [com.mongodb.client.model.Filters.eq](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/model/Filters.html#eq-java.lang.String-TItem-) method to create the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```java and(eq(, ), eq(, ) ...) ``` To specify equality conditions, use the [Filters.eq()](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-core/com/mongodb/client/model/Filters.html#eq\(java.lang.String,TItem\)) method to create the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```kotlin and(eq(, ), eq(, ) ...) ``` To specify equality conditions, use `:` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```javascript { : , ... } ``` To specify equality conditions, use ` => ` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```php [ => , ... ] ``` To specify equality conditions, use ` => ` expressions in the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```ruby { => , ... } ``` To specify equality conditions, use the `com.mongodb.client.model.Filters.eq_` method to create the [query filter document:](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) ```scala and(equal(, ), equal(, ) ...) ``` To specify equality conditions, construct a filter using the [Eq](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/Overload_MongoDB_Driver_FilterDefinitionBuilder_1_Eq.htm) method: ```csharp Builders.Filter.Eq(, ); ``` To specify equality conditions, use the `bson.D` type to create a filter document: ```go filter := bson.D{{"", }} ``` The following example selects all documents from the `sample_mflix.movies` collection where `rated` equals `"PG-13"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: The following example selects all documents from the `inventory` collection where `status` equals `"D"`: ```javascript db.movies.find( { rated: "PG-13" } ) ``` Copy the following filter into the Compass query bar and click Find: ```javascript { status: "D" } ``` **Note:** The MongoDB Compass query bar autocompletes the current query based on the keys in your collection's documents, including keys in embedded sub-documents. ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW ("status", BCON_UTF8 ("D")); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` ```python cursor = db.inventory.find({"status": "D"}) ``` ```python cursor = db.inventory.find({"status": "D"}) ``` ```java findIterable = collection.find(eq("status", "D")); ``` ```java findPublisher = collection.find(eq("status", "D")); ``` ```kotlin val findFlow = collection .find(eq("status", "D")) ``` ```javascript const cursor = db.collection('inventory').find({ status: 'D' }); ``` ```php $cursor = $db->inventory->find(['status' => 'D']); ``` ```ruby client[:inventory].find(status: 'D') ``` ```scala findObservable = collection.find(equal("status", "D")) ``` ```csharp var filter = Builders.Filter.Eq("status", "D"); var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{{"status", "D"}}, ) ``` This operation uses a query predicate of `{ rated: "PG-13" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM movies WHERE rated = "PG-13" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` This operation uses a query predicate of `{ status: "D" }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "D" ``` ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators ## Specify Conditions Using Query Operators A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```javascript { : { : }, ... } ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```javascript { : { : }, ... } ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```c { : { : }, ... } ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```python { : { : }, ... } ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```python { : { : }, ... } ``` In addition to the equality condition, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the [com.mongodb.client.model.Filters](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/model/Filters.html) helper methods to facilitate the creation of filter documents. For example: ```java and(gte(, ), lt(, ), eq(, )) ``` In addition to the equality condition, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the [com.mongodb.client.model.Filters](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/model/Filters.html) helper methods to facilitate the creation of filter documents. For example: ```java and(gte(, ), lt(, ), eq(, )) ``` In addition to the equality condition, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the [com.mongodb.client.model.Filters](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-core/com/mongodb/client/model/Filters.html) helper methods to facilitate the creation of filter documents. For example: ```kotlin and(gte(, ), lt(, ), eq(, )) ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```javascript { : { : }, ... } ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```php [ => [ => ], ... ] ``` A [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) can use the [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify conditions in the following form: ```ruby { => { => }, ... } ``` In addition to the equality condition, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the `com.mongodb.client.model.Filters_` helper methods to facilitate the creation of filter documents. For example: ```scala and(gte(, ), lt(, ), equal(, )) ``` In addition to the equality filter, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the [FilterDefinitionBuilder](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/T_MongoDB_Driver_FilterDefinitionBuilder_1.htm) methods to create a filter document. For example: ```csharp var builder = Builders.Filter; builder.And(builder.Eq(, ), builder.Lt(, )); ``` In addition to the equality filter, MongoDB provides various [query operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-selectors) to specify filter conditions. Use the bson package to create query operators for filter documents. For example: ```go filter := bson.D{ {"$and", bson.A{ bson.D{{"field1", bson.D{{"$eq", value1}}}}, bson.D{{"field2", bson.D{{"$lt", value2}}}}, }}, } To match an array field against any value in a list of values, use the :query:`$in` operator. ``` The following example retrieves all documents from the `sample_mflix.movies` collection where `rated` equals either `"G"` or `"PG-13"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: The following example retrieves all documents from the `inventory` collection where `status` equals either `"A"` or `"D"`: ```javascript db.movies.find( { rated: { $in: [ "G", "PG-13" ] } } ) ``` Copy the following filter into the Compass query bar and click Find: ```javascript { status: { $in: [ "A", "D" ] } } ``` ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW ( "status", "{", "$in", "[", BCON_UTF8 ("A"), BCON_UTF8 ("D"), "]", "}"); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` ```python cursor = db.inventory.find({"status": {"$in": ["A", "D"]}}) ``` ```python cursor = db.inventory.find({"status": {"$in": ["A", "D"]}}) ``` ```java findIterable = collection.find(in("status", "A", "D")); ``` ```java findPublisher = collection.find(in("status", "A", "D")); ``` ```kotlin val findFlow = collection .find(`in`("status", "A", "D")) ``` ```javascript const cursor = db.collection('inventory').find({ status: { $in: ['A', 'D'] } }); ``` ```php $cursor = $db->inventory->find(['status' => ['$in' => ['A', 'D']]]); ``` ```ruby client[:inventory].find(status: { '$in' => %w[A D] }) ``` ```scala findObservable = collection.find(in("status", "A", "D")) ``` ```csharp var filter = Builders.Filter.In("status", new[] { "A", "D" }); var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{{"status", bson.D{{"$in", bson.A{"A", "D"}}}}}) ``` **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. **Note:** Although you can use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator for this query, use the [`$in`](https://www.mongodb.com/docs/manual/reference/operator/query/in.md#mongodb-query-op.-in) operator instead of [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) when performing equality checks on the same field. The operation uses a query predicate of `{ rated: { $in: [ "G", "PG-13" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM movies WHERE rated in ("G", "PG-13") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` The operation uses a query predicate of `{ status: { $in: [ "A", "D" ] } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status in ("A", "D") ``` For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) For the complete list of MongoDB query operators, see [Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates.md#std-label-query-predicates-ref) ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. ## Specify `AND` Conditions A compound query can specify conditions for more than one field in the collection's documents. Implicitly, a logical `AND` conjunction connects the clauses of a compound query so that the query selects the documents in the collection that match all the conditions. The following example retrieves all documents in the `sample_mflix.movies` collection where `rated` equals `"G"` **and** `runtime` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `90`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the `inventory` collection where `status` equals `"A"` **and** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: ```javascript db.movies.find( { rated: "G", runtime: { $lt: 90 } } ) ``` Copy the following filter into the Compass query bar and click Find: ```javascript { status: "A", qty: { $lt: 30 } } ``` ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW ( "status", BCON_UTF8 ("A"), "qty", "{", "$lt", BCON_INT64 (30), "}"); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` ```python cursor = db.inventory.find({"status": "A", "qty": {"$lt": 30}}) ``` ```python cursor = db.inventory.find({"status": "A", "qty": {"$lt": 30}}) ``` ```java findIterable = collection.find(and(eq("status", "A"), lt("qty", 30))); ``` ```java findPublisher = collection.find(and(eq("status", "A"), lt("qty", 30))); ``` ```kotlin val findFlow = collection .find(and(eq("status", "A"), lt("qty", 30))) ``` ```javascript const cursor = db.collection('inventory').find({ status: 'A', qty: { $lt: 30 } }); ``` ```php $cursor = $db->inventory->find([ 'status' => 'A', 'qty' => ['$lt' => 30], ]); ``` ```ruby client[:inventory].find(status: 'A', qty: { '$lt' => 30 }) ``` ```scala findObservable = collection.find(and(equal("status", "A"), lt("qty", 30))) ``` ```csharp var builder = Builders.Filter; var filter = builder.And(builder.Eq("status", "A"), builder.Lt("qty", 30)); var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{ {"status", "A"}, {"qty", bson.D{{"$lt", 30}}}, }) ``` The operation uses a query predicate of `{ rated: "G", runtime: { $lt: 90 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM movies WHERE rated = "G" AND runtime < 90 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` The operation uses a query predicate of `{ status: "A", qty: { $lt: 30 } }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND qty < 30 ``` See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. See [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) for other MongoDB comparison operators. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. ## Specify `OR` Conditions Use the [`$or`](https://www.mongodb.com/docs/manual/reference/operator/query/or.md#mongodb-query-op.-or) operator to specify a compound query that joins each clause with a logical `OR` conjunction. The query selects documents that match at least one condition. The following example retrieves all documents in the `sample_mflix.movies` collection where `rated` equals `"G"` **or** `runtime` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `90`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: The following example retrieves all documents in the collection where `status` equals `"A"` **or** `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30`: ```javascript db.movies.find( { $or: [ { rated: "G" }, { runtime: { $lt: 90 } } ] } ) ``` Copy the following filter into the Compass query bar and click Find: ```javascript { $or: [ { status: "A" }, { qty: { $lt: 30 } } ] } ``` ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW ( "$or", "[", "{", "status", BCON_UTF8 ("A"), "}","{", "qty", "{", "$lt", BCON_INT64 (30), "}", "}", "]"); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` ```python cursor = db.inventory.find({"$or": [{"status": "A"}, {"qty": {"$lt": 30}}]}) ``` ```python cursor = db.inventory.find({"$or": [{"status": "A"}, {"qty": {"$lt": 30}}]}) ``` ```java findIterable = collection.find(or(eq("status", "A"), lt("qty", 30))); ``` ```java findPublisher = collection.find(or(eq("status", "A"), lt("qty", 30))); ``` ```kotlin val findFlow = collection .find(or(eq("status", "A"), lt("qty", 30))) ``` ```javascript const cursor = db.collection('inventory').find({ $or: [{ status: 'A' }, { qty: { $lt: 30 } }] }); ``` ```php $cursor = $db->inventory->find([ '$or' => [ ['status' => 'A'], ['qty' => ['$lt' => 30]], ], ]); ``` ```ruby client[:inventory].find('$or' => [ { status: 'A' }, { qty: { '$lt' => 30 } } ]) ``` ```scala findObservable = collection.find(or(equal("status", "A"), lt("qty", 30))) ``` ```csharp var builder = Builders.Filter; var filter = builder.Or(builder.Eq("status", "A"), builder.Lt("qty", 30)); var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{ { "$or", bson.A{ bson.D{{"status", "A"}}, bson.D{{"qty", bson.D{{"$lt", 30}}}}, }, }, }) ``` The operation uses a query predicate of `{ $or: [ { rated: 'G' }, { runtime: { $lt: 90 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM movies WHERE rated = "G" OR runtime < 90 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` The operation uses a query predicate of `{ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] }`, which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" OR qty < 30 ``` **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) **Note:** Queries with [comparison operators](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/comparison.md#std-label-query-selectors-comparison) are subject to [Type Bracketing in Query Predicates.](https://www.mongodb.com/docs/manual/reference/mql/query-predicates/type-bracketing.md#std-label-type-bracketing) ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions ## Specify `AND` as well as `OR` Conditions In the following example, the compound query document selects all documents in the `sample_mflix.movies` collection where `rated` equals `"G"` **and** *either* `runtime` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `90` *or* `title` starts with the character `T`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: In the following example, the compound query document selects all documents in the collection where `status` equals `"A"` **and** *either* `qty` is less than ([`$lt`](https://www.mongodb.com/docs/manual/reference/operator/query/lt.md#mongodb-query-op.-lt)) `30` *or* `item` starts with the character `p`: ```javascript db.movies.find( { rated: "G", $or: [ { runtime: { $lt: 90 } }, { title: /^T/ } ] } ) ``` Copy the following filter into the Compass query bar and click Find: ```javascript { status: "A", $or: [ { qty: { $lt: 30 } }, { item: /^p/ } ] } ``` ```c mongoc_collection_t *collection; bson_t *filter; mongoc_cursor_t *cursor; collection = mongoc_database_get_collection (db, "inventory"); filter = BCON_NEW ( "status", BCON_UTF8 ("A"), "$or", "[", "{", "qty", "{", "$lt", BCON_INT64 (30), "}", "}","{", "item", BCON_REGEX ("^p", ""), "}", "]"); cursor = mongoc_collection_find_with_opts (collection, filter, NULL, NULL); ``` ```python cursor = db.inventory.find( {"status": "A", "$or": [{"qty": {"$lt": 30}}, {"item": {"$regex": "^p"}}]} ) ``` ```python cursor = db.inventory.find( {"status": "A", "$or": [{"qty": {"$lt": 30}}, {"item": {"$regex": "^p"}}]} ) ``` ```java findIterable = collection.find( and(eq("status", "A"), or(lt("qty", 30), regex("item", "^p"))) ); ``` ```java findPublisher = collection.find( and(eq("status", "A"), or(lt("qty", 30), regex("item", "^p"))) ); ``` ```kotlin val findFlow = collection .find( and(eq("status", "A"), or(lt("qty", 30), regex("item", "^p"))) ) ``` ```javascript const cursor = db.collection('inventory').find({ status: 'A', $or: [{ qty: { $lt: 30 } }, { item: { $regex: '^p' } }] }); ``` ```php $cursor = $db->inventory->find([ 'status' => 'A', '$or' => [ ['qty' => ['$lt' => 30]], // Alternatively: ['item' => new \MongoDB\BSON\Regex('^p')] ['item' => ['$regex' => '^p']], ], ]); ``` ```ruby client[:inventory].find(status: 'A', '$or' => [ { qty: { '$lt' => 30 } }, { item: { '$regex' => BSON::Regexp::Raw.new('^p') } } ]) ``` ```scala findObservable = collection.find(and( equal("status", "A"), or(lt("qty", 30), regex("item", "^p"))) ) ``` ```csharp var builder = Builders.Filter; var filter = builder.And( builder.Eq("status", "A"), builder.Or(builder.Lt("qty", 30), builder.Regex("item", new BsonRegularExpression("^p")))); var result = collection.Find(filter).ToList(); ``` ```go cursor, err := coll.Find( context.TODO(), bson.D{ {"status", "A"}, {"$or", bson.A{ bson.D{{"qty", bson.D{{"$lt", 30}}}}, bson.D{{"item", bson.Regex{Pattern: "^p", Options: ""}}}, }}, }) ``` The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: The operation uses a query predicate of: ```javascript { rated: 'G', $or: [ { runtime: { $lt: 90 } }, { title: { $regex: '^T' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM movies WHERE rated = "G" AND ( runtime < 90 OR title LIKE "T%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` ```javascript { status: 'A', $or: [ { qty: { $lt: 30 } }, { item: { $regex: '^p' } } ] } ``` which corresponds to the following SQL statement: ```sql SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%") ``` **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). **Note:** MongoDB supports regular expression [`$regex`](https://www.mongodb.com/docs/manual/reference/operator/query/regex.md#mongodb-query-op.-regex) queries to perform string pattern matches. Regular expression syntax differs between `mongosh` and drivers. `mongosh` uses JavaScript regex literals (for example, `{ title: /^T/ }`). The drivers use the equivalent `$regex` operator (for example, `{ title: { $regex: '^T' } }`). ## Query Documents with MongoDB Atlas This example uses the [sample movies dataset](https://www.mongodb.com/docs/atlas/sample-data/sample-mflix/). To load the sample dataset into your MongoDB Atlas deployment, see [Load Sample Data.](https://www.mongodb.com/docs/atlas/sample-data/#std-label-load-sample-data) To project fields for a query in MongoDB Atlas, follow these steps: 1. In the MongoDB Atlas UI, go to the Clusters page for your project. If it's not already displayed, select the organization that contains your desired project from the Organizations menu in the navigation bar. If it's not already displayed, select your project from the Projects menu in the navigation bar. In the sidebar, click Clusters under the Database heading. The [Clusters](https://cloud.mongodb.com/go?l=https%3A%2F%2Fcloud.mongodb.com%2Fv2%2F%3Cproject%3E%23%2Fclusters) page displays. 2. Navigate to the collection For the cluster that contains the sample data, click Browse Collections. In the left navigation pane, select the `sample_mflix` database. Select the `movies` collection. 3. Specify the Filter field Specify the [query filter document](https://www.mongodb.com/docs/manual/core/documents-other-uses.md#std-label-document-query-filter) in the Filter field. A query filter document uses [query operators](https://www.mongodb.com/docs/manual/core/csfle/reference/supported-operations.md#std-label-csfle-supported-query-operators) to specify search conditions. Copy the following query filter document into the Filter search bar: ```javascript { year: 1924 } ``` 4. Click Apply The query returns all documents in the `sample_mflix.movies` collection where the `year` field matches `1924`. ## Additional Query Tutorials For more query examples, see: - [Query on Embedded/Nested Documents](https://www.mongodb.com/docs/manual/tutorial/query-embedded-documents.md) - [Query an Array](https://www.mongodb.com/docs/manual/tutorial/query-arrays.md) - [Query an Array of Embedded Documents](https://www.mongodb.com/docs/manual/tutorial/query-array-of-documents.md) - [Project Fields to Return from Query](https://www.mongodb.com/docs/manual/tutorial/project-fields-from-query-results.md) - [Query for Null or Missing Fields](https://www.mongodb.com/docs/manual/tutorial/query-for-null-fields.md) ## Behavior ### Cursor The [`db.collection.find()`](https://www.mongodb.com/docs/manual/reference/method/db.collection.find.md#mongodb-method-db.collection.find) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. The Find operation opens a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents of the collection based on the find query. For more information on sampling, see the [Compass FAQ.](https://www.mongodb.com/docs/compass/current/faq.md#std-label-compass-faq) The [mongoc\_collection\_find\_with\_opts](https://mongoc.org/libmongoc/current/mongoc_collection_find_with_opts.html) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. The [`pymongo.collection.Collection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. See the PyMongo documentation for [iterating over a cursor.](https://pymongo.readthedocs.io/en/stable/tutorial.html#querying-for-more-than-one-document) The [`pymongo.asynchronous.collection.AsyncCollection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. The [com.mongodb.client.MongoCollection.find](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/MongoCollection.html#find--) method returns an instance of the [com.mongodb.client.FindIterable](https://mongodb.github.io/mongo-java-driver/3.4/javadoc/com/mongodb/client/FindIterable.html) interface. [com.mongodb.reactivestreams.client.MongoCollection.find](http://mongodb.github.io/mongo-java-driver-reactivestreams/1.6/javadoc/com/mongodb/reactivestreams/client/MongoCollection.html#find\(\)) returns an instance of the [com.mongodb.reactivestreams.client.FindPublisher](http://mongodb.github.io/mongo-java-driver-reactivestreams/1.6/javadoc/com/mongodb/reactivestreams/client/FindPublisher.html) interface. The [MongoCollection.find()](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-kotlin-coroutine/mongodb-driver-kotlin-coroutine/com.mongodb.kotlin.client.coroutine/-mongo-collection/find.html) method returns an instance of the [FindFlow](https://mongodb.github.io/mongo-java-driver/5.11/apidocs/driver-kotlin-coroutine/mongodb-driver-kotlin-coroutine/com.mongodb.kotlin.client.coroutine/-find-flow/index.html) class. The [Collection.find()](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#find) method returns a [cursor.](http://mongodb.github.io/node-mongodb-native/3.6/api/Cursor.html) The [`MongoDB\\Collection::find()`](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-find.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--find--) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. See the MongoDB PHP Library documentation for [iterating over a cursor.](https://www.mongodb.com/docs/php-library/upcoming/crud/query/cursor.md#std-label-php-cursors-iterate) The [Mongo::Collection#find()](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Collection.html#find-instance_method) method returns a [CollectionView](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Collection/View.html), which is an `Enumerable`. A [Cursor](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Cursor.html) is created when the `View` is enumerated; for example, by calling `#to_a()` or `#each()`. You can also get an `Enumerator` by calling `#to_enum()` on the `View`. See the Ruby driver API documentation for [iterating over a cursor.](https://www.mongodb.com/docs/ruby-driver/current/api/Mongo/Cursor.html#each-instance_method) The [collection.find()](http://mongodb.github.io/mongo-scala-driver/2.9/scaladoc/org/mongodb/scala/MongoCollection.html#find[C]\(filter:org.mongodb.scala.bson.conversions.Bson\)\(implicite:org.mongodb.scala.bson.DefaultHelper.DefaultsTo[C,TResult],implicitct:scala.reflect.ClassTag[C]\):org.mongodb.scala.FindObservable[C]) method returns the find [Observable](http://mongodb.github.io/mongo-scala-driver/2.1/reference/observables/). The [MongoCollection.Find()](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_Find.htm) method returns a [cursor](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md) to the matching documents. See the MongoDB .NET/C# Driver documentation for [iterating over a cursor](https://www.mongodb.com/docs/drivers/csharp/v2.19/fundamentals/crud/read-operations/retrieve/#find-multiple-documents). The [Collection.Find](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Collection.Find) function returns a [Cursor](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Cursor) to the matching documents. See the [Cursor](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Cursor) documentation for more information. ### Concurrent Updates While Using a Cursor As a cursor returns documents, other operations may run in the background and affect the results, depending on the read concern level. For details, see [Read Isolation, Consistency, and Recency.](https://www.mongodb.com/docs/manual/core/read-isolation-consistency-recency.md#std-label-read-isolation-consistency-recency) ### Read Isolation For reads to [replica sets](https://www.mongodb.com/docs/manual/replication.md#std-label-replication) and replica set [shards](https://www.mongodb.com/docs/manual/sharding.md#std-label-sharding-background), read concern lets clients choose an isolation level for their reads. For more information, see [Read Concern.](https://www.mongodb.com/docs/manual/reference/read-concern.md) ### Query Result Format When you run a find operation with a MongoDB driver or `mongosh`, MongoDB returns a [cursor](https://www.mongodb.com/docs/manual/core/cursors.md#std-label-cursors) that manages query results. Query results are not returned as an array of documents. To learn how to iterate through documents in a cursor, see your [driver's documentation](https://www.mongodb.com/docs/drivers/). If you are using `mongosh`, see [Iterate a Cursor in `mongosh`.](https://www.mongodb.com/docs/manual/tutorial/iterate-a-cursor.md#std-label-read-operations-cursors) ### Query Spill A query that exceeds either 100 megabytes or the available memory spills to disk. It writes intermediate data to storage to save memory, which can cause lowered performance. Use the [`allowDiskUseByDefault`](https://www.mongodb.com/docs/manual/reference/parameters.md#mongodb-parameter-param.allowDiskUseByDefault) parameter or [`cursor.allowDiskUse()`](https://www.mongodb.com/docs/manual/reference/method/cursor.allowdiskuse.md#mongodb-method-cursor.allowDiskUse) method to configure this behavior. For Atlas deployments using [Atlas Infinite](https://www.mongodb.com/docs/atlas/infinite/atlas-infinite-landing.md#std-label-atlas-infinite-edition), compute and storage are separated, so queries spill to the compute node executing the query. For more information, see [query spilling on Atlas Infinite clusters.](https://www.mongodb.com/docs/atlas/reference/alert-conditions.md#std-label-atlas-infinite-query-spilling) ## Additional Methods and Options You can also read documents from a collection with: - The [`db.collection.findOne()`](https://www.mongodb.com/docs/manual/reference/method/db.collection.findone.md#mongodb-method-db.collection.findOne) method - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline) **Note:** The [`db.collection.findOne()`](https://www.mongodb.com/docs/manual/reference/method/db.collection.findone.md#mongodb-method-db.collection.findOne) method performs the same operation as [`db.collection.find()`](https://www.mongodb.com/docs/manual/reference/method/db.collection.find.md#mongodb-method-db.collection.find) with a limit of 1. MongoDB Compass also accepts the following query bar options: | [Project](https://www.mongodb.com/docs/compass/current/query/project/) | Specify which fields to return in the resulting data. | | --- | --- | | [Sort](https://www.mongodb.com/docs/compass/current/query/sort/) | Specify the sort order of the returned documents. | | [Skip](https://www.mongodb.com/docs/compass/current/query/skip/) | Specify the first n-number of documents to skip before returning the result set. | | [Limit](https://www.mongodb.com/docs/compass/current/query/limit/) | Specify the maximum number of documents to return. | You can also read documents from a collection with: - [mongoc\_find\_and\_modify\_opts\_t](https://mongoc.org/libmongoc/current/mongoc_find_and_modify_opts_t.html) You can also read documents from a collection with: - [`pymongo.collection.Collection.find_one`](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find_one) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). See the [PyMongo Aggregation Examples](https://pymongo.readthedocs.io/en/stable/examples/aggregation.html). **Note:** The [`pymongo.collection.Collection.find_one`](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find_one) method performs the same operation as the the [`pymongo.collection.Collection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.find) method with a limit of 1. You can also read documents from a collection with: - [`pymongo.asynchronous.collection.AsyncCollection.find_one`](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find_one) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline) **Note:** The [`pymongo.asynchronous.collection.AsyncCollection.find_one`](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find_one) method performs the same operation as [`pymongo.asynchronous.collection.AsyncCollection.find`](https://pymongo.readthedocs.io/en/stable/api/pymongo/asynchronous/collection.html#pymongo.asynchronous.collection.AsyncCollection.find) with a limit of 1. You can also read documents from a collection with the [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [Java Synchronous Driver Aggregation Examples.](https://mongodb.github.io/mongo-java-driver/3.4/driver/tutorials/aggregation/) You can also read documents from a collection with the [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [Java Asynchronous Driver Aggregation Examples.](http://mongodb.github.io/mongo-java-driver/3.4/driver-async/tutorials/aggregation/) You can also read documents from a collection with the [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [Kotlin Coroutine Driver Find Operation Examples.](https://www.mongodb.com/docs/drivers/kotlin/coroutine/current/fundamentals/crud/read-operations/retrieve/) You can also read documents from a collection with: - [Collection.findOne()](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#findOne) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [aggregation tutorial.](http://mongodb.github.io/node-mongodb-native/3.6/tutorials/aggregation/) **Note:** The [Collection.findOne()](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#findOne) method performs the same operation as [Collection.find()](http://mongodb.github.io/node-mongodb-native/3.6/api/Collection.html#find) with a limit of 1. You can also read documents from a collection with: - [`MongoDB\\Collection::findOne()`](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-findOne.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--findOne--) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [aggregation example.](https://www.mongodb.com/docs/php-library/upcoming/aggregation.md#std-label-php-aggregation) **Note:** The [`MongoDB\\Collection::findOne()`](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-findOne.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--findOne--) method performs the same operation as [`MongoDB\\Collection::find()`](https://www.mongodb.com/docs/php-library/upcoming/reference/method/MongoDBCollection-find.md#mongodb-phpmethod-phpmethod.MongoDB-Collection--find--) with a limit of 1. You can also read documents from a collection with the [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [aggregation examples.](https://www.mongodb.com/docs/ruby-driver/current/tutorials/ruby-driver-aggregation/) You can also read documents from a collection with the [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [aggregate method.](http://mongodb.github.io/mongo-scala-driver/2.9/scaladoc/org/mongodb/scala/MongoCollection.html#aggregate[C]\(pipeline:Seq[org.mongodb.scala.bson.conversions.Bson]\)\(implicite:org.mongodb.scala.bson.DefaultHelper.DefaultsTo[C,TResult],implicitct:scala.reflect.ClassTag[C]\):org.mongodb.scala.AggregateObservable[C]) You can also read documents from a collection with: - [MongoCollection.FindOne()](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_FindOne_1.htm) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see the [LINQ documentation.](https://www.mongodb.com/docs/drivers/csharp/current/fundamentals/linq/) **Note:** The [MongoCollection.FindOne()](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_FindOne_1.htm) method performs the same operation as [MongoCollection.Find()](https://mongodb.github.io/mongo-csharp-driver/2.10/apidocs/html/M_MongoDB_Driver_MongoCollection_1_Find.htm) with a limit of 1. You can also read documents from a collection with: - [Collection.FindOne](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Collection.FindOne) - The [`$match`](https://www.mongodb.com/docs/manual/reference/operator/aggregation/match.md#mongodb-pipeline-pipe.-match) pipeline stage in an [aggregation pipeline](https://www.mongodb.com/docs/manual/core/aggregation-pipeline.md#std-label-aggregation-pipeline). For more information, see [Collection.Aggregate.](https://godoc.org/github.com/mongodb/mongo-go-driver/mongo#Collection.Aggregate)