📄️ 👐 WHERE → .find()
Similar to SQL's WHERE clause, the .find() method in MongoDB retrieves documents from a collection that matches a specified query.
📄️ 👐 SELECT → projection
In SQL, the SELECT statement allows us to specify which columns to retrieve from a table. Similarly, in MongoDB, we use projection in the .find() method to control which fields to include (or exclude) in query results.
📄️ 👐 ORDER BY → .sort() & LIMIT → .limit()
In SQL, we use ORDER BY to sort query results and LIMIT to restrict the number of returned rows. MongoDB provides the .sort() and .limit() methods to achieve the same.
📄️ 👐 INSERT → insertOne() & DELETE → deleteOne()
MongoDB provides two methods for inserting documents into a collection:
📄️ 👐 UPDATE → updateOne(), updateMany()
To modify existing documents, MongoDB provides: