MongoDB -按名称、姓氏或Name+Surname查找用户

{
  "_id": ObjectId("..."),
  "name": "John",
  "surname": "Doe"
}

db.users.find({ "name": { $regex: /^John$/i } })

db.users.find({ "surname": { $regex: /^Doe$/i } })

db.users.find({ $or: [
  { "name": { $regex: /^John$/i }, "surname": { $regex: /^Doe$/i } },
  { "name": { $regex: /^Doe$/i }, "surname": { $regex: /^John$/i } }
]})

db.users.find({ "name": "John" })

db.users.find({ "surname": "Doe" })

db.users.find({ $and: [
  { "name": "John" },
  { "surname": "Doe" }
]})