Specific FirstName और LastName वाले documents find करने के लिए $and के साथ $in का उपयोग करें। MongoDB find() में implement करें।
Collection बनाना
> db.demo692.insertOne({FirstName:"Chris","LastName":"Brown"});
{ "acknowledged" : true, "insertedId" : ObjectId("5ea585dca7e81adc6a0b396a") }
> db.demo692.insertOne({FirstName:"John","LastName":"Brown"});
{ "acknowledged" : true, "insertedId" : ObjectId("5ea585e2a7e81adc6a0b396b") }
> db.demo692.insertOne({FirstName:"John","LastName":"Smith"});
{ "acknowledged" : true, "insertedId" : ObjectId("5ea585e7a7e81adc6a0b396c") }
> db.demo692.insertOne({FirstName:"John","LastName":"Doe"});
{ "acknowledged" : true, "insertedId" : ObjectId("5ea585efa7e81adc6a0b396d") }
> db.demo692.insertOne({FirstName:"Adam","LastName":"Smith"});
{ "acknowledged" : true, "insertedId" : ObjectId("5ea585faa7e81adc6a0b396e") }
सभी Documents Display करना
> db.demo692.find();
Output:
{ "_id" : ObjectId("5ea585dca7e81adc6a0b396a"), "FirstName" : "Chris", "LastName" : "Brown" }
{ "_id" : ObjectId("5ea585e2a7e81adc6a0b396b"), "FirstName" : "John", "LastName" : "Brown" }
{ "_id" : ObjectId("5ea585e7a7e81adc6a0b396c"), "FirstName" : "John", "LastName" : "Smith" }
{ "_id" : ObjectId("5ea585efa7e81adc6a0b396d"), "FirstName" : "John", "LastName" : "Doe" }
{ "_id" : ObjectId("5ea585faa7e81adc6a0b396e"), "FirstName" : "Adam", "LastName" : "Smith" }
Specific FirstName और LastName Find Query
> db.demo692.find({$and:[
... {FirstName: {$in: ["Chris", "John"]}},
... {LastName:{$in:["Brown", "Smith"]}}
... ]
... });
Output:
{ "_id" : ObjectId("5ea585dca7e81adc6a0b396a"), "FirstName" : "Chris", "LastName" : "Brown" }
{ "_id" : ObjectId("5ea585e2a7e81adc6a0b396b"), "FirstName" : "John", "LastName" : "Brown" }
{ "_id" : ObjectId("5ea585e7a7e81adc6a0b396c"), "FirstName" : "John", "LastName" : "Smith" }
व्याख्या: $and दोनों conditions combine करता है: FirstName "Chris" या "John" में से कोई हो, **और** LastName "Brown" या "Smith" में से कोई हो। "John Doe" match नहीं हुआ (LastName "Doe" नहीं है list में)। "Adam Smith" match नहीं हुआ (FirstName "Adam" नहीं है list में)।
