ใช้ Regular Expression (Regex) พร้อมตัวเลือก i เพื่อค้นหาแบบไม่สนใจตัวพิมพ์เล็กใหญ่
ตัวอย่างการใช้งาน
สร้างคอลเลกชัน caseInsensitiveDemo พร้อมชื่อที่แตกต่างในรูปแบบพิมพ์:
> db.caseInsensitiveDemo.insertOne({"UserName":"David"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f6fec8d10a061296a3c45") }
> db.caseInsensitiveDemo.insertOne({"UserName":"DAVID"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f6ff28d10a061296a3c46") }
> db.caseInsensitiveDemo.insertOne({"UserName":"david"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f6ffa8d10a061296a3c47") }
> db.caseInsensitiveDemo.insertOne({"UserName":"Carol"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f70008d10a061296a3c48") }
> db.caseInsensitiveDemo.insertOne({"UserName":"Mike"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f70058d10a061296a3c49") }
> db.caseInsensitiveDemo.insertOne({"UserName":"Sam"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f70098d10a061296a3c4a") }
> db.caseInsensitiveDemo.insertOne({"UserName":"daVID"});
{ "acknowledged" : true, "insertedId" : ObjectId("5c7f70138d10a061296a3c4b") }
แสดงข้อมูลทั้งหมด:
> db.caseInsensitiveDemo.find().pretty();
{"_id" : ObjectId("5c7f6fec8d10a061296a3c45"), "UserName" : "David" }
{"_id" : ObjectId("5c7f6ff28d10a061296a3c46"), "UserName" : "DAVID" }
{"_id" : ObjectId("5c7f6ffa8d10a061296a3c47"), "UserName" : "david" }
{"_id" : ObjectId("5c7f70008d10a061296a3c48"), "UserName" : "Carol" }
{"_id" : ObjectId("5c7f70058d10a061296a3c49"), "UserName" : "Mike" }
{"_id" : ObjectId("5c7f70098d10a061296a3c4a"), "UserName" : "Sam" }
{"_id" : ObjectId("5c7f70138d10a061296a3c4b"), "UserName" : "daVID" }
ค้นหาแบบ case-insensitive ด้วย Regex /^david$/i:
> db.caseInsensitiveDemo.find({UserName: /^david$/i }).pretty();
{"_id" : ObjectId("5c7f6fec8d10a061296a3c45"), "UserName" : "David" }
{"_id" : ObjectId("5c7f6ff28d10a061296a3c46"), "UserName" : "DAVID" }
{"_id" : ObjectId("5c7f6ffa8d10a061296a3c47"), "UserName" : "david" }
{"_id" : ObjectId("5c7f70138d10a061296a3c4b"), "UserName" : "daVID" }
ผลลัพธ์รวมทุกรูปแบบการพิมพ์ของ "david"
