Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
The $gt operator selects documents where the value of a field is greater than a specified value. When working with embedded documents (hash/object structures), use dot notation to access nested fields within the $gt query. Syntax db.collection.find({ "parentField.nestedField": { $gt: value } }); Sample Data db.performQueryDemo.insertMany([ { "PlayerDetails": { "PlayerScore": 1000, "PlayerLevel": 2 ... Read More
In MongoDB, you can check for null values using the $type operator with type number 10 or alias "null". This operator specifically matches fields that contain explicit null values, not missing fields or empty strings. Syntax db.collection.find({"fieldName": { $type: 10 }}); // OR db.collection.find({"fieldName": { $type: "null" }}); Sample Data Let's create a collection with different types of values to demonstrate null checking ? db.mongoDbEqualDemo.insertMany([ {"Age": 34}, {"Age": ""}, {"Age": null}, {"Age": 56}, ... Read More
To drop a collection in MongoDB that has special characters like two dashes in its name, you need to use the getCollection() method instead of direct dot notation, since MongoDB cannot parse collection names with special characters using standard syntax. Syntax db.getCollection("collectionNameWithSpecialCharacters").drop(); Create Sample Collection First, let's create a collection with two dashes in the name ? db.createCollection("company--EmployeeInformation"); { "ok" : 1 } Insert Sample Data Add some documents to the collection ? db.getCollection("company--EmployeeInformation").insertMany([ {"CompanyName": "Amazon", "EmployeeName": "Chris"}, ... Read More
The $exists operator checks whether a field exists in a document, while $ne (not equal) filters documents where a field value does not match the specified value. Combining both operators helps find documents with existing fields that contain meaningful data. Syntax // $exists operator db.collection.find({ "fieldName": { "$exists": true/false } }); // $ne operator db.collection.find({ "fieldName": { "$ne": "value" } }); // Combined usage db.collection.find({ "$and": [ { "fieldName": { "$exists": true } }, ... Read More
To fetch a specific record in MongoDB using ObjectId with the findOne() method, pass the ObjectId as the query criteria. The findOne() method returns the first document that matches the specified ObjectId. Syntax db.collection.findOne({"_id": ObjectId("objectid_value")}); Create Sample Data db.findOneWorkingDemo.insertMany([ {"ClientId": 1, "ClientName": "Larry", "ClientAge": 26}, {"ClientId": 2, "ClientName": "Chris", "ClientAge": 28}, {"ClientId": 3, "ClientName": "Robert", "ClientAge": 34} ]); { "acknowledged": true, "insertedIds": [ ... Read More
To calculate timestamp difference in hours in MongoDB, use the aggregate framework with $subtract and $divide operators. The key is subtracting timestamps (which returns milliseconds) and dividing by 3600000 to convert to hours. Syntax db.collection.aggregate([ { $project: { DifferenceInHours: { $divide: [ ... Read More
Yes, MongoDB provides several methods to display query results in a better, more readable format instead of the default single-line output. The most common approaches are findOne() and find().toArray(). Syntax // Display single document in formatted JSON db.collection.findOne(); // Display all documents in formatted JSON array db.collection.find().toArray(); Sample Data Let us first create a collection with sample documents ? db.betterFormatDemo.insertMany([ {"StudentName": "Adam Smith", "StudentScores": [98, 67, 89]}, {"StudentName": "John Doe", "StudentScores": [67, 89, 56]}, {"StudentName": "Sam Williams", "StudentScores": [45, ... Read More
To decrement only a single value in MongoDB, use the $inc operator with a negative value. This allows you to decrease a numeric field by a specified amount while targeting only one document. Syntax db.collection.update( { field: "matchValue" }, { $inc: { numericField: -decrementValue } } ); Create Sample Data db.decrementingOperationDemo.insertMany([ { "ProductName": "Product-1", "ProductPrice": 756 }, { "ProductName": "Product-2", "ProductPrice": 890 }, { "ProductName": "Product-3", "ProductPrice": 994 }, ... Read More
To search for documents matching the first item in an array in MongoDB, use dot notation with index 0 to target the first element directly. This approach allows you to query specific fields within the first array element. Syntax db.collection.find({"arrayName.0.fieldName": "value"}); Sample Data db.matchingFirstItemInTheArrayDemo.insertMany([ { "ClientDetails": [ { "ClientName": "Larry", ... Read More
To exclude the _id field without explicitly including other fields in MongoDB's aggregation framework, use the $project stage with _id: 0 and selectively include only the fields you need. Syntax db.collection.aggregate([ { $project: { _id: 0, "field1": 1, "field2": 1 } ... Read More