- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 1349 Articles for MongoDB
114 Views
For this, set regex in MongoDB find(). Let us create a collection with documents −> db.demo228.insertOne({"Subjects":["MongoDB", "Java"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3fa51f03d395bdc213473b") } > db.demo228.insertOne({"Subjects":["MongoDB", "Java", "MySQL"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3fa52c03d395bdc213473c") }Display all documents from a collection with the help of find() method −> db.demo228.find();This will produce the following output −{ "_id" : ObjectId("5e3fa51f03d395bdc213473b"), "Subjects" : [ "MongoDB", "Java" ] } { "_id" : ObjectId("5e3fa52c03d395bdc213473c"), "Subjects" : [ "MongoDB", "Java", "MySQL" ] }Following is the query to find documents where at least one item from an array is not in the ... Read More
400 Views
Let us create a collection with documents −> db.demo227.insertOne({"_id":"101", "Name":"Chris"}); { "acknowledged" : true, "insertedId" : "101" } > db.demo227.insertOne({"_id":"102", "Name":"Bob"}); { "acknowledged" : true, "insertedId" : "102" }Display all documents from a collection with the help of find() method −> db.demo227.find();This will produce the following output −{ "_id" : "101", "Name" : "Chris" } { "_id" : "102", "Name" : "Bob" }Following is the query to update a set of documents from a list of key value pairs −> var bulkUpdateValue = [{"_id": "101", "Name": "Robert"}, ... {"_id": "102", "Name": "Sam"} ...]; > var bulkUpdate = db.demo227.initializeUnorderedBulkOp(); > ... Read More
445 Views
For this, use the $project. The $project takes a document that can specify the inclusion of fields, the suppression of the _id field, the addition of new fields, and the resetting of the values of existing fieldsLet us first create a collection with documents −> db.demo226.insertOne({"Name":"Chris", "Age":21}); { "acknowledged" : true, "insertedId" : ObjectId("5e3f9be803d395bdc2134738") } > db.demo226.insertOne({"Name":"Bob", "Age":20}); { "acknowledged" : true, "insertedId" : ObjectId("5e3f9bf003d395bdc2134739") } > db.demo226.insertOne({"Name":"David", "Age":22}); { "acknowledged" : true, "insertedId" : ObjectId("5e3f9bf803d395bdc213473a") }Display all documents from a collection with the help of find() method −> db.demo226.find();This will produce the following ... Read More
358 Views
To get the last two values, use MongoDB $slice. Let us create a collection with documents −> db.demo173.insertOne({"ListOfValues":[10,40,100,560,700,900]}); { "acknowledged" : true, "insertedId" : ObjectId("5e383a4f9e4f06af551997e4") }Display all documents from a collection with the help of find() method −> db.demo173.find().pretty();This will produce the following output −{ "_id" : ObjectId("5e383a4f9e4f06af551997e4"), "ListOfValues" : [ 10, 40, 100, 560, 700, 900 ] }Following is the query to get the last two values −> db.demo173.find({}, { "ListOfValues": { "$slice": -2 } } );This will produce the following output −{ "_id" : ObjectId("5e383a4f9e4f06af551997e4"), "ListOfValues" : [ 700, 900 ] }
98 Views
To remove item from array, use $pull in MongoDB. Let us create a collection with documents −> db.demo224.insertOne({"ListOfTechnology":["Spring", "Hibernate", "Java"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee6d103d395bdc2134733") } > db.demo224.insertOne({"ListOfTechnology":["Groovy"]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee6ec03d395bdc2134734") }Display all documents from a collection with the help of find() method −> db.demo224.find();This will produce the following output −{ "_id" : ObjectId("5e3ee6d103d395bdc2134733"), "ListOfTechnology" : [ "Spring", "Hibernate", "Java" ] } { "_id" : ObjectId("5e3ee6ec03d395bdc2134734"), "ListOfTechnology" : [ "Groovy" ] }Following is the query to remove item from array in MongoDB −>db.demo224.update({_id:ObjectId("5e3ee6d103d395bdc2134733")}, {$pull:{"ListOfTechnology":"Java"}}); WriteResult({ "nMatched" : 1, "nUpserted" : ... Read More
240 Views
To compare multiple properties, use $where in MongoDB. Let us create a collection with documents −> db.demo223.insertOne({"Scores":[56, 78]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee4ca03d395bdc2134730") } > db.demo223.insertOne({"Scores":[88, 45]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee4d103d395bdc2134731") } > db.demo223.insertOne({"Scores":[98, 79]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee4d803d395bdc2134732") }Display all documents from a collection with the help of find() method −> db.demo223.find();This will produce the following output −{ "_id" : ObjectId("5e3ee4ca03d395bdc2134730"), "Scores" : [ 56, 78 ] } { "_id" : ObjectId("5e3ee4d103d395bdc2134731"), "Scores" : [ 88, 45 ] } { "_id" : ObjectId("5e3ee4d803d395bdc2134732"), "Scores" : ... Read More
415 Views
To add new array element in a MongoDB document, use $(projection) along with update(). Let us create a collection with documents −>db.demo222.insertOne({"details":[{"StudentName":"Chris", "StudentMarks":78}, {"StudentName":"David", "StudentMarks":89}]}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee31703d395bdc213472f") }Display all documents from a collection with the help of find() method −> db.demo222.find().pretty();This will produce the following output −{ "_id" : ObjectId("5e3ee31703d395bdc213472f"), "details" : [ { "StudentName" : "Chris", "StudentMarks" : 78 }, { "StudentName" : "David", "StudentMarks" ... Read More
62 Views
For searching a specific word, use /searchWord/ with regex. Let us create a collection with documents −> db.demo221.insertOne({"Details":{"StudentName":"Chris", "StudentAge":21}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee15d03d395bdc213472b") } > db.demo221.insertOne({"Details":{"StudentName":"John", "StudentAge":20}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee16503d395bdc213472c") } > db.demo221.insertOne({"Details":{"StudentName":"Bob", "StudentAge":22}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee16b03d395bdc213472d") } > db.demo221.insertOne({"Details":{"StudentName":"john", "StudentAge":24}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ee17303d395bdc213472e") }Display all documents from a collection with the help of find() method −> db.demo221.find();This will produce the following output −{ "_id" : ObjectId("5e3ee15d03d395bdc213472b"), "Details" : { "StudentName" : "Chris", "StudentAge" : 21 } ... Read More
149 Views
To get all embedded documents, use $project in MongoDB. Let us create a collection with documents −> db.demo220.insertOne({ ... "id":101, ... "FullName" : "John Doe", ... "EmailId" : "john12@gmail.com", ... "ShippingDate" : new ISODate(), ... "details" : { "_id" :1001, "isMarried" :true } ...} ...); { "acknowledged" : true, "insertedId" : ObjectId("5e3eaf5b03d395bdc213471d") } > db.demo220.insertOne( ...{ ... "id":102, ... "FullName" : "John Smith", ... "EmailId" : "johnsmith@gmail.com", ... "ShippingDate" : new ISODate(), ... "details" : { "_id" :1002, "isMarried" :false } ... } ... ); { "acknowledged" ... Read More
183 Views
To search for a specific domain name, use /i. Let us create a collection with documents −> db.demo219.insertOne({"details":{"WebsiteURL":"www.EXAMPLE.com"}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3e667203d395bdc2134718") } > db.demo219.insertOne({"details":{"WebsiteURL":"www.gmail.com"}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3e667803d395bdc2134719") } > db.demo219.insertOne({"details":{"WebsiteURL":"www.example.com"}}); { "acknowledged" : true, "insertedId" : ObjectId("5e3e667f03d395bdc213471a") }Display all documents from a collection with the help of find() method −> db.demo219.find();This will produce the following output −{ "_id" : ObjectId("5e3e667203d395bdc2134718"), "details" : { "WebsiteURL" : "www.EXAMPLE.com" } } { "_id" : ObjectId("5e3e667803d395bdc2134719"), "details" : { "WebsiteURL" : "www.gmail.com" } } { "_id" : ObjectId("5e3e667f03d395bdc213471a"), "details" : ... Read More