For more information, see db.collection.find() , db.collection.distinct() , db.collection.findOne() , $ne $and , $or , $gt , $lt , $exists , $lte , $regex , limit() , skip() , explain() , sort() , and count() . MongoDB Documentation, Release 3.0.4 Update Records The following table presents the various SQL statements related to updating existing records in tables and the corresponding MongoDB statements. SQL Update Statements MongoDB update() Statements UPDATE users SET status = "C" WHERE age > 25 db.users.update( { age: { $gt: 25 } }, { $set: { status: "C" } }, { multi: true } ) UPDATE users SET age = age + 3 WHERE status = "A" db.users.update( { status: "A" } , { $inc: { age: 3 } }, { multi: true } ) For more information, see db.collection.update() , $set , $inc , and $gt . Delete Records The following table presents the various SQL statements related to deleting records from tables and the corresponding MongoDB statements. For more information, see db.collection.remove() . Additional Resources • Transitioning from SQL to MongoDB (Presentation) 16 • Best Practices for Migrating from RDBMS to MongoDB (Webinar) 17 • SQL vs. MongoDB Day 1-2 18 • SQL vs. MongoDB Day 3-5 19 • MongoDB vs. SQL Day 14 20 • MongoDB and MySQL Compared 21 $^{16}$http://www.mongodb.com/presentations/webinar-transitioning-sql-mongodb?jmp=docs $^{17}$http://www.mongodb.com/webinar/best-practices-migration?jmp=docs $^{18}$http://www.mongodb.com/blog/post/mongodb-vs-sql-day-1-2?jmp=docs $^{19}$http://www.mongodb.com/blog/post/mongodb-vs-sql-day-3-5?jmp=docs $^{20}$http://www.mongodb.com/blog/post/mongodb-vs-sql-day-14?jmp=docs $^{21}$http://www.mongodb.com/mongodb-and-mysql-compared?jmp=docs Chapter 3. MongoDB CRUD Operations 136 SQL Delete Statements MongoDB remove() Statements DELETE FROM users WHERE status = "D" db.users.remove( { status: "D" } ) DELETE FROM users db.users.remove({})