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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to prepend string to entire column in MongoDB?
To prepend a string to an entire column in MongoDB, use the $concat operator within the aggregation framework. The $concat operator combines the prepend string with the existing field value. Syntax db.collection.aggregate([ { $project: { "fieldName": { $concat: ["prependString", "$fieldName"] } ...
Read MoreHow to perform intersection of sets between the documents in a single collection in MongoDB?
To find the intersection of sets between documents in a single MongoDB collection, use the $setIntersection operator within an aggregation pipeline. This operator returns an array containing elements that appear in all specified arrays. Syntax { $project: { "result": { $setIntersection: ["$array1", "$array2", "$array3", ...] } } } Sample Data db.setInterSectionDemo.insertMany([ {"_id": 101, ...
Read MoreHow to find datatype of all the fields in MongoDB?
To find the datatype of all fields in MongoDB, use the typeof operator with findOne() to check individual field types, or use aggregation pipeline to analyze multiple fields systematically. Syntax typeof db.collectionName.findOne().fieldName; Sample Data Let us first create a collection with documents ? db.findDataTypeDemo.insertOne({ "ClientName": "Chris", "isMarried": false, "age": 25, "salary": 50000.50 }); { "acknowledged": true, "insertedId": ObjectId("5ccf2064dceb9a92e6aa1952") } Display the document to ...
Read MoreHow to do alphanumeric sort in MongoDB?
To perform alphanumeric sort in MongoDB, use the collation method with numericOrdering: true. This ensures that numeric portions within strings are sorted numerically rather than lexically (e.g., "STU101" comes before "STU1010"). Syntax db.collection.find().sort({field: 1}).collation({ locale: "en_US", numericOrdering: true }); Sample Data db.alphanumericSortDemo.insertMany([ {"StudentId": "STU1010"}, {"StudentId": "STU1101"}, {"StudentId": "STU1901"}, {"StudentId": "STU908"}, {"StudentId": "STU101"} ]); Display all documents to see the insertion order ? ...
Read MoreReverse array field in MongoDB?
To reverse array field in MongoDB, you can use the forEach() method to iterate through documents and manually reorder array elements using the $set operator. Syntax db.collection.find().forEach(function (document) { var reversedArray = document.arrayField.reverse(); db.collection.update(document, { $set: {arrayField: reversedArray } }); }); Sample Data Let us first create a collection with documents ? db.reverseArrayDemo.insertOne({"Skills":["C", "Java"]}); { "acknowledged" : true, "insertedId" : ObjectId("5ccddf99dceb9a92e6aa1946") } Following is the query to display all documents from ...
Read MoreHow to pull all elements from an array in MongoDB without any condition?
To pull all elements from an array in MongoDB without any condition, use the $set operator to replace the entire array field with an empty array []. This effectively removes all elements from the specified array. Syntax db.collection.update( { "field": "value" }, { $set: { "arrayField": [] } } ); Sample Data Let us create a collection with documents containing arrays ? db.pullAllElementDemo.insertMany([ { "StudentId": 101, ...
Read MoreUpdate object at specific Array Index in MongoDB?
To update object at specific array index in MongoDB, use the $set operator with dot notation to target the exact position in nested arrays. Specify the array path with numeric indices to access objects at specific locations. Syntax db.collection.update( { "field": "value" }, { $set: { "arrayName.index1.index2.fieldName": "newValue" } } ); Sample Data Let us first create a collection with nested array structure: db.updateObjectDemo.insertOne({ id: 101, "StudentDetails": [ ...
Read MoreHow to increment a field in MongoDB?
To increment a field in MongoDB, use the $inc operator with the update() method. The $inc operator increases the numeric value of a field by a specified amount. Syntax db.collection.update( { "query": "criteria" }, { $inc: { "fieldName": incrementValue } } ); Sample Data Let us create a collection with player scores ? db.incrementDemo.insertMany([ { "PlayerScore": 100 }, { "PlayerScore": 290 }, { "PlayerScore": 560 } ]); { ...
Read MoreWhat is the syntax for boolean values in MongoDB?
MongoDB supports native boolean values true and false. You can query boolean fields using equality operators like $eq and $ne, or by direct value matching. Syntax // Direct boolean matching db.collection.find({"booleanField": true}); db.collection.find({"booleanField": false}); // Using $eq operator db.collection.find({"booleanField": {$eq: true}}); // Using $ne operator db.collection.find({"booleanField": {$ne: false}}); Sample Data Let us create a collection with boolean values − db.booleanQueryDemo.insertMany([ {"UserName": "John", "UserAge": 23, "isMarried": true}, {"UserName": "Chris", "UserAge": 21, "isMarried": false}, {"UserName": "Robert", "UserAge": 24, ...
Read MoreRemove and update the existing record in MongoDB?
To remove and update existing records in MongoDB, use the $pull operator which removes elements from an array that match specified criteria. This operator effectively updates the document by removing the matching array elements. Syntax db.collection.update( { "filter_condition": "value" }, { "$pull": { "arrayField": { "field": "valueToRemove" } } } ); Sample Data Let us create a collection with documents containing user details in an array ? db.removeDemo.insertMany([ { "UserName": "Larry", ...
Read More