How do i search for a document in mongodb?

This operation corresponds to the following SQL statement:

The following example selects from the inventory collection all documents where the status equals "D":

This operation corresponds to the following SQL statement:

SELECT * FROM inventory WHERE status = "D"

The following example retrieves all documents from the inventory collection where status equals either "A" or "D":

Note

Although you can express this query using the $or operator, use the $in operator rather than the $or operator when performing equality checks on the same field.

The operation corresponds to the following SQL statement:

SELECT * FROM inventory WHERE status in ("A", "D")

Refer to the Query and Projection Operators document for the complete list of MongoDB query operators.

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 inventory collection where the status equals "A" and qty is less than ($lt) 30:

The operation corresponds to the following SQL statement:

SELECT * FROM inventory WHERE status = "A" AND qty < 30

See comparison operators for other MongoDB comparison operators.

Using the $or operator, you can specify a compound query that joins each clause with a logical OR conjunction so that the query selects the documents in the collection that match at least one condition.

The following example retrieves all documents in the collection where the status equals "A" or qty is less than ($lt) 30:

The operation corresponds to the following SQL statement:

SELECT * FROM inventory WHERE status = "A" OR qty < 30

Note

SELECT * FROM inventory WHERE status = "A" AND ( qty < 30 OR item LIKE "p%")

For additional query examples, see:

• Query on Embedded/Nested Documents

• Query an Array

• Query an Array of Embedded Documents

• Project Fields to Return from Query

• Query for Null or Missing Fields

For MongoDB Atlas users, MongoDB's Atlas Search supports fine-grained text indexing and a rich query language for fast, relevant search results. To learn more about full-text search indexes and $search queries, see:

• Atlas Search Aggregation Pipeline Stages

• Defining Atlas Search Indexes

• Running Atlas Search Queries

Atlas Search also offers common analyzers for parsing text for full-text search, including support for over 40 language-specific analyzers.

For on-premises (non-Atlas) deployments, MongoDB's text search capability supports query operations that perform a text search of string content. To perform text search, MongoDB uses a text index and the $text operator.

Note

Views do not support text search.

To learn more about text search for on-premises deployments, see:

• Text Indexes

• Text Search Operators

MongoDB also supports text search for various languages. See Text Search Languages for a list of supported languages.