RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/mongodb/mongodb-comparison-query-operators/ below:

MongoDB - Comparison Query Operators

Last Updated : 12 Jul, 2025

MongoDB provides powerful comparison query operators to filter and retrieve documents based on field values. These operators help developers perform precise queries, enabling efficient data retrieval and manipulation. MongoDB uses various comparison query operators to compare the values of the documents

In this article, we will explore MongoDB comparison query operators, their syntax, use cases, and practical examples to help us master data filtering in MongoDB. Whether we're a beginner or an experienced developer, this article will ensure we understand how to use these operators effectively.

What are Comparison Query Operators in MongoDB?

Comparison query operators allow users to filter documents based on specific conditions. These operators can be used to find records that match, differ, or fall within a range of values. They include operators like $eq, $ne, $gt, $lt, $gte, $lte, $in, and $nin. These operators help in efficiently querying and retrieving documents based on numerical, string, or date field comparisons.

To filter documents based on specific field values.
To compare numerical, string, or date fields.
To refine search queries for optimized performance.

Below is a list of commonly used MongoDB comparison query operators:

Operators Description $eq Matches the values of the fields that are equal to a specified value. $ne Matches all values of the field that are not equal to a specified value. $gt Matches values of the fields that are greater than a specified value. $gte Matches values of the fields that are greater than equal to the specified value. $lt Matches values of the fields that are less than a specified value $lte Matches values of the fields that are less than equal to the specified value $in Matches any of the values specified in an array. $nin Matches none of the values specified in an array. MongoDB Comparison Operator Examples

For better understanding, let’s look at real-world examples using a sample "contributor" collection in a database named "GeeksforGeeks".

Database: GeeksforGeeks
Collection: contributor
Document: three documents that contain the details of the contributors in the form of field-value pairs.

Example 1: Using $nin operator:

In this example, we are retrieving only those employee’s documents whose name is not "Amit" or "Suman".

Query:

 db.contributor.find({name: {$nin: [&quot;Amit&quot;, &quot;Suman&quot;]}}).pretty()

Output

Example 2: Using $in operator

In this example, we are retrieving only those employee's documents whose name is either "Amit" or "Suman".

Query:

db.contributor.find({name: {$in: [&quot;Amit&quot;, &quot;Suman&quot;]}}).pretty()

Output:

Example 3: Using $lt operator

In this example, we are selecting those documents where the value of the salary field is less than 2000.

Query:

db.contributor.find({salary: {$lt: 2000}}).pretty()

Output:

Example 4: Using $eq operator

In this example, we are selecting those documents where the value of the branch field is equal to "CSE".

Query:

 db.contributor.find({branch: {$eq: &quot;CSE&quot;}}).pretty()

Output:

Example 5: Using $ne operator

In this example, we are selecting those documents where the value of the branch field is not equal to CSE.

Query:

 db.contributor.find({branch: {$ne: &quot;CSE&quot;}}).pretty()

Output:

Example 6: Matching values using $gt operator:

In this example, we are selecting those documents where the value of the salary field is greater than 1000.

Query:

db.contributor.find({salary: {$gt: 1000}}).pretty()

Output:

Example 7: Using $gte operator

In this example, we are selecting those documents where the value of the joiningYear field is greater than equals to 2017.

Query:

db.contributor.find({joiningYear: {$gte: 2017}})

Output:

Example 8: Using $lte operator

In this example, we are selecting those documents where the value of the salary field is less than equals to 1000.

Query:

db.contributor.find({salary: {$lte: 1000}}).pretty()

Output:

Best Practices for Using MongoDB Comparison Operators

To optimize performance and ensure efficiency, follow these best practices when using comparison operators:

Use Indexing: Ensure fields used in comparisons are indexed to speed up query execution.
Avoid Large Scans: Use selective queries to prevent full collection scans.
Optimize $in Queries: Avoid large arrays in $in queries as they can slow down performance.
Use Projection: Limit returned fields using projections to reduce query load.
Utilize $expr: For comparing two fields within the same document, use $expr for efficient comparisons.

Conclusion

In this article, we learned about different comparison operators in MongoDB. We discussed the definition and use of MongoDB comparison operators. There are many operators that are used for comparison query in MongoDB. We have covered various comparison operators and understood their workings with examples. By implementing these operators effectively, we can enhance our MongoDB query performance and ensure efficient data retrieval for your applications.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4