MongoDB में केस-इनसेंसिटिव सर्च के लिए क्वेरी

पहले एक कलेक्शन बनाते हैं:

> db.demo186.insertOne({"UserEmailId":"JOHN@GMAIL.COM","UserName":"John"}); 
{ "acknowledged": true, "insertedId": ObjectId("5e399d769e4f06af55199808") }
> db.demo186.insertOne({"UserEmailId":"chris@gmail.com","UserName":"chris"}); 
{ "acknowledged": true, "insertedId": ObjectId("5e399d879e4f06af55199809") }
> db.demo186.insertOne({"UserEmailId":"DAVID@GMAIL.COM","UserName":"David"}); 
{ "acknowledged": true, "insertedId": ObjectId("5e399d979e4f06af5519980a") }

सभी डॉक्यूमेंट्स देखें:

> db.demo186.find();

आउटपुट:

{ "_id": ObjectId("5e399d769e4f06af55199808"), "UserEmailId": "JOHN@GMAIL.COM", "UserName": "John" }
{ "_id": ObjectId("5e399d879e4f06af55199809"), "UserEmailId": "chris@gmail.com", "UserName": "chris" }
{ "_id": ObjectId("5e399d979e4f06af5519980a"), "UserEmailId": "DAVID@GMAIL.COM", "UserName": "David" }

केस-इनसेंसिटिव सर्च के लिए क्वेरी:

> var userMailId = [ /john@gmail.com/i, /david@gmail.com/i ]
> db.demo186.find({
    '$or': [
        { 'UserEmailId': { '$in': userMailId } },
        { 'UserName': 'John' }
    ]
})

परिणाम:

{ "_id": ObjectId("5e399d769e4f06af55199808"), "UserEmailId": "JOHN@GMAIL.COM", "UserName": "John" }
{ "_id": ObjectId("5e399d979e4f06af5519980a"), "UserEmailId": "DAVID@GMAIL.COM", "UserName": "David" }