SQL Query - Example

Here are some examples of MongoDB queries and their equivalent SQL queries:

1. Find all documents in a collection:

MongoDB

db.myCollection.find()

SQL

SELECT * FROM myCollection;

2. Find documents with a specific value in a field:

MongoDB

db.myCollection.find({ field: "value" })

SQL

SELECT * FROM myCollection WHERE field = 'value';

3. Find documents with multiple criteria:

MongoDB

db.myCollection.find({ field1: "value1", field2: "value2" })

SQL

SELECT * FROM myCollection WHERE field1 = 'value1' AND field2 = 'value2';

4. Find documents with a value greater than or equal to a certain number:

MongoDB

db.myCollection.find({ field: { $gte: 10 } })

SQL

SELECT * FROM myCollection WHERE field >= 10;

5. Find documents with a value in an array:

MongoDB

db.myCollection.find({ field: { $in: ["value1", "value2"] } })

SQL

SELECT * FROM myCollection WHERE field IN ('value1', 'value2');

6. Find documents with a value that matches a regular expression:

MongoDB

db.myCollection.find({ field: /pattern/ })

SQL

SELECT * FROM myCollection WHERE field REGEXP 'pattern';

7. Find documents and limit the number of results:

MongoDB

db.myCollection.find().limit(10)

SQL

SELECT * FROM myCollection LIMIT 10;