Find MongoDB records with Price less than a specific value

To check the records with Price less than a specific value, use $lt. Let us create a collection with documents −

> db.demo728.insertOne({Price:75});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5eab413c43417811278f589b")
}
> db.demo728.insertOne({Price:59});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5eab414043417811278f589c")
}
> db.demo728.insertOne({Price:79});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5eab414543417811278f589d")
}
> db.demo728.insertOne({Price:89});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5eab414843417811278f589e")
}

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

> db.demo728.find();

This will produce the following output −

{ "_id" : ObjectId("5eab413c43417811278f589b"), "Price" : 75 }
{ "_id" : ObjectId("5eab414043417811278f589c"), "Price" : 59 }
{ "_id" : ObjectId("5eab414543417811278f589d"), "Price" : 79 }
{ "_id" : ObjectId("5eab414843417811278f589e"), "Price" : 89 }

Following is the query to find records based on a condition −

> db.demo728.find({Price:{$lt:80}});

This will produce the following output −

{ "_id" : ObjectId("5eab413c43417811278f589b"), "Price" : 75 }
{ "_id" : ObjectId("5eab414043417811278f589c"), "Price" : 59 }
{ "_id" : ObjectId("5eab414543417811278f589d"), "Price" : 79 }

AmitDiwan

Published on 15-May-2020 09:15:48

• Related Questions & Answers
• Query MongoDB for a datetime value less than NOW?
• MongoDB query to group records and display a specific value with dot notation
• MongoDB query to match documents with array values greater than a specific value
• Find value above a specific value in MongoDB documents?
• Find out the records of students with more than a specific score in MySQL?
• Find records on or after a specific date in MongoDB?
• Find document with array that contains a specific value in MongoDB
• Match MongoDB documents with field value greater than a specific number and fetch them?
• Find the document by field name with a specific value in MongoDB?
• Find records with a specific last digit in column with MySQL
• Find MongoDB document with array containing the maximum occurrence of a specific value
• Mask array elements less than a given value in Numpy
• Find minimum value with MongoDB?
• How to check whether a column value is less than or greater than a certain value in R?
• Check if any value in an R vector is greater than or less than a certain value.