Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MongoDB Articles
Page 4 of 111
Match MongoDB documents with field value greater than a specific number and fetch them?
To match MongoDB documents with field values greater than a specific number, use the $gt operator in your query. This operator filters documents where the specified field value exceeds the given threshold. Syntax db.collection.find({ "fieldName": { "$gt": value } }); // Using with aggregation pipeline db.collection.aggregate([ { $match: { "fieldName": { "$gt": value } } } ]); Sample Data db.demo730.insertMany([ { "Name": "Chris", "Marks": 33 }, { "Name": "David", "Marks": 89 }, { "Name": "Chris", "Marks": ...
Read MoreMass insertion in MongoDB
For mass insertion in MongoDB, use the insertMany() method to insert multiple documents into a collection in a single operation. This is more efficient than inserting documents individually using multiple insert() calls. Syntax db.collection.insertMany([ { document1 }, { document2 }, { document3 } ]); Example Let us create a collection with multiple bank customer documents ? db.demo729.insertMany([ { BankName: "HDFC Bank", cardType: "Credit", "CustomerName": [{Name: "Chris", Age: 25}] }, { BankName: "ICICI ...
Read MoreFind MongoDB records with Price less than a specific value
To find MongoDB records with Price less than a specific value, use the $lt (less than) comparison operator. This operator filters documents where the specified field value is less than the given value. Syntax db.collection.find({ "field": { $lt: value } }); Sample Data Let us create a collection with sample price documents ? db.demo728.insertMany([ {Price: 75}, {Price: 59}, {Price: 79}, {Price: 89} ]); { "acknowledged": ...
Read MoreMongoDB query to search for string like "@email" in the field values
To search for strings containing "@email" in MongoDB field values, use regular expressions with the find() method. The i flag enables case-insensitive matching. Syntax db.collection.find({"fieldName": /pattern/flags}); Sample Data Let us create a collection with documents − db.demo727.insertMany([ {UserId: "John@email.com"}, {UserId: "John@yahoo.com"}, {UserId: "Chris@EMAIL.com"} ]); { "acknowledged" : true, "insertedIds" : [ ObjectId("5eab375f43417811278f5898"), ObjectId("5eab376043417811278f5899"), ObjectId("5eab376143417811278f589a") ...
Read MoreHow can I count the documents in an array based on the value of a specific field?
To count documents in an array based on the value of a specific field, use the $unwind operator to flatten the array, followed by $match to filter, and $group to count the matching elements. Syntax db.collection.aggregate([ { $unwind: "$arrayField" }, { $match: { "arrayField.fieldName": "targetValue" } }, { $group: { _id: null, count: { $sum: 1 } }} ]); Sample Data ...
Read MoreSet filtering conditions for nested array in MongoDB
To set filtering conditions for nested arrays in MongoDB, use the $filter operator combined with $anyElementTrue and $map in an aggregation pipeline. This approach allows you to filter outer array elements based on conditions within deeply nested arrays. Syntax db.collection.aggregate([ { $addFields: { "arrayField": { $filter: { ...
Read MoreHow to count a cursor's iteration in MongoDB?
To count a cursor's iteration in MongoDB, you need to use custom logic with a while loop along with a find() cursor. This allows you to iterate through documents and count specific conditions during traversal. Syntax var cursor = db.collection.find(); var count = 0; while (cursor.hasNext()) { var document = cursor.next(); // Apply your counting logic here if (condition) { count++; } } Sample Data db.demo724.insertMany([ ...
Read MoreGet count of array elements from a specific field in MongoDB documents?
To count array elements from a specific field in MongoDB, use the $size operator within an aggregation pipeline. This operator returns the number of elements in an array field for each document. Syntax db.collection.aggregate([ { $project: { count: { $size: "$arrayFieldName" } } } ]); Sample Data db.demo723.insertMany([ {"Subject": ["MySQL", "MongoDB"]}, {"Subject": ["C"]}, {"Subject": ["C++", "Java", "Python"]} ]); { "acknowledged": true, "insertedIds": [ ...
Read MoreCount by multiple fields with MongoDB aggregation
To count by multiple fields in MongoDB, use the $facet operator combined with $group and $sum. The $facet processes multiple aggregation pipelines within a single stage on the same set of input documents. Syntax db.collection.aggregate([ { $facet: { "pipeline1": [ /* aggregation stages */ ], "pipeline2": [ /* aggregation stages */ ] } ...
Read MoreUpdate all the values of a field with a specific string in MongoDB?
To update all the values of a field with a specific string in MongoDB, use the update() method with an empty filter and the multi: true option to affect all documents in the collection. Syntax db.collection.update( {}, { $set: { "fieldName": "newValue" } }, { multi: true } ); Sample Data db.demo720.insertMany([ { "SubjectName": "MySQL" }, { "SubjectName": "Java" }, { "SubjectName": "C" }, { ...
Read More