SQL

where with multiple conditions in mongodb

-- mongodb
db.people.find(
    { status: "A",
      age: 50 }
)
-- sql
SELECT *
FROM people
WHERE status = "A"
AND age = 50

-- mongodb
db.people.find(
    { $or: [ { status: "A" } , { age: 50 } ] }
)
-- sql
SELECT *
FROM people
WHERE status = "A"
OR age = 50

$match multiple conditions mongodb

-- mongodb
db.posts.find(
    { status: "A",
      comments: 50 }
)