คิวรี MongoDB เลือกข้อมูลหลายเงื่อนไขด้วยตัวดำเนินการ $or

สร้างคอลเลกชันตัวอย่าง

> db.demo270.insertOne({"ClientName":"Chirs","Age":34});
{ "acknowledged": true, "insertedId": ObjectId("5e481e371627c0c63e7dbab8") }
> db.demo270.insertOne({"ClientName":"David","Age":31});
{ "acknowledged": true, "insertedId": ObjectId("5e481e3d1627c0c63e7dbab9") }
> db.demo270.insertOne({"ClientName":"Bob","Age":31});
{ "acknowledged": true, "insertedId": ObjectId("5e481e431627c0c63e7dbaba") }
> db.demo270.insertOne({"ClientName":"Carol","Age":36});
{ "acknowledged": true, "insertedId": ObjectId("5e481e491627c0c63e7dbabb") }

แสดงข้อมูลทั้งหมด

> db.demo270.find();

{ "_id": ObjectId("5e481e371627c0c63e7dbab8"), "ClientName": "Chirs", "Age": 34 }
{ "_id": ObjectId("5e481e3d1627c0c63e7dbab9"), "ClientName": "David", "Age": 31 }
{ "_id": ObjectId("5e481e431627c0c63e7dbaba"), "ClientName": "Bob", "Age": 31 }
{ "_id": ObjectId("5e481e491627c0c63e7dbabb"), "ClientName": "Carol", "Age": 36 }

คิวรีด้วย $or

ค้นหาเอกสารที่ ClientName = "Carol" หรือ Age = 31:

> db.demo270.find({
  "$or": [
    { "ClientName": "Carol" },
    { "Age": 31 }
  ]
});

ผลลัพธ์

{ "_id": ObjectId("5e481e3d1627c0c63e7dbab9"), "ClientName": "David", "Age": 31 }
{ "_id": ObjectId("5e481e431627c0c63e7dbaba"), "ClientName": "Bob", "Age": 31 }
{ "_id": ObjectId("5e481e491627c0c63e7dbabb"), "ClientName": "Carol", "Age": 36 }