MongoDB-এ SQL "LIKE" এর সমতুল্য অপারেটর

MongoDB-এ SQL "LIKE" এর সমতুল্য কাজ করার জন্য $regex অপারেটর ব্যবহার করতে পারেন। বুঝতে ডকুমেন্টসহ একটি কলেকশন তৈরি করি। ডকুমেন্টসহ কলেকশন তৈরির কোয়েরি নিম্নরূপ:

> db.sqlLikeDemo.insertOne({"UserName":"John Smith","UserAge":24}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e124afe5c1d2279d6a5") } > db.sqlLikeDemo.insertOne({"UserName":"John Doe","UserAge":21}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e264afe5c1d2279d6a6") } > db.sqlLikeDemo.insertOne({"UserName":"Chris Williams","UserAge":22}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e404afe5c1d2279d6a7") } > db.sqlLikeDemo.insertOne({"UserName":"Robert Taylor","UserAge":26}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e4d4afe5c1d2279d6a8") } > db.sqlLikeDemo.insertOne({"UserName":"John Brown","UserAge":27}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e6c4afe5c1d2279d6a9") } > db.sqlLikeDemo.insertOne({"UserName":"Mike Brown","UserAge":23}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e794afe5c1d2279d6aa") } > db.sqlLikeDemo.insertOne({"UserName":"Larry Smith","UserAge":24}); { "acknowledged" : true, "insertedId" : ObjectId("5c912e8c4afe5c1d2279d6ab") }

find() মেথড ব্যবহার করে কলেকশন থেকে সব ডকুমেন্ট প্রদর্শন করি। কোয়েরিটি নিম্নরূপ:

> db.sqlLikeDemo.find().pretty();

আউটপুট নিম্নরূপ:

{ "_id" : ObjectId("5c912e124afe5c1d2279d6a5"), "UserName" : "John Smith", "UserAge" : 24 } { "_id" : ObjectId("5c912e264afe5c1d2279d6a6"), "UserName" : "John Doe", "UserAge" : 21 } { "_id" : ObjectId("5c912e404afe5c1d2279d6a7"), "UserName" : "Chris Williams", "UserAge" : 22 } { "_id" : ObjectId("5c912e4d4afe5c1d2279d6a8"), "UserName" : "Robert Taylor", "UserAge" : 26 } { "_id" : ObjectId("5c912e6c4afe5c1d2279d6a9"), "UserName" : "John Brown", "UserAge" : 27 } { "_id" : ObjectId("5c912e794afe5c1d2279d6aa"), "UserName" : "Mike Brown", "UserAge" : 23 } { "_id" : ObjectId("5c912e8c4afe5c1d2279d6ab"), "UserName" : "Larry Smith", "UserAge" : 24 }

SQL "LIKE" ক্লজের মতো কাজ করার কোয়েরি অর্থাৎ "UserName" ক্ষেত্রে "John" থাকা রেকর্ড খুঁজে বের করা:

> db.sqlLikeDemo.find({"UserName":{"$regex": "John"}}).pretty();

আউটপুট নিম্নরূপ:

{ "_id" : ObjectId("5c912e124afe5c1d2279d6a5"), "UserName" : "John Smith", "UserAge" : 24 } { "_id" : ObjectId("5c912e264afe5c1d2279d6a6"), "UserName" : "John Doe", "UserAge" : 21 } { "_id" : ObjectId("5c912e6c4afe5c1d2279d6a9"), "UserName" : "John Brown", "UserAge" : 27 }