Dùng toán tử $eq (bằng) và $ne (khác) cho boolean. Tạo collection:
> db.booleanQueryDemo.insertOne({"UserName":"John","UserAge":23,"isMarried":true});
{ "acknowledged" : true, "insertedId" : ObjectId("5cc815c08f9e6ff3eb0ce44a") }
> db.booleanQueryDemo.insertOne({"UserName":"Chris","UserAge":21,"isMarried":false});
{ "acknowledged" : true, "insertedId" : ObjectId("5cc815d08f9e6ff3eb0ce44b") }
> db.booleanQueryDemo.insertOne({"UserName":"Robert","UserAge":24,"isMarried":false});
{ "acknowledged" : true, "insertedId" : ObjectId("5cc815dc8f9e6ff3eb0ce44c") }
> db.booleanQueryDemo.insertOne({"UserName":"David","UserAge":26,"isMarried":true});
{ "acknowledged" : true, "insertedId" : ObjectId("5cc815ed8f9e6ff3eb0ce44d") }
Hiển thị tất cả:
> db.booleanQueryDemo.find().pretty();
Trường hợp 1: Tìm isMarried = false ($eq: false):
> db.booleanQueryDemo.find({isMarried: {$eq: false}}).pretty();
Kết quả: Chris, Robert.
Trường hợp 2: Tìm isMarried = true ($ne: false):
> db.booleanQueryDemo.find({isMarried: {$ne: false}}).pretty();
Kết quả: John, David.