Is it possible to make a case-insensitive query in MongoDB?

MongoDBDatabaseBig Data Analytics

Yes, you can use regexp to make a case-insensitive query in MongoDB. The syntax is as follows:

db.yourCollectionName.find({"yourFieldName":/^yourvalue$/i});

To understand the above syntax, let us create a collection with some documents. The query to create a collection with documents is as follows:

> db.caseInsensitiveDemo.insertOne({"Name":"John"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c6d7a67f2db199c1278e7ef")
}
> db.caseInsensitiveDemo.insertOne({"Name":"JOHN"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c6d7ad6f2db199c1278e7f0")
}

Display all documents from a collection with the help of find(). The query is as follows:

> db.caseInsensitiveDemo.find();

The following is the output:

{ "_id" : ObjectId("5c6d7a67f2db199c1278e7ef"), "Name" : "John" }
{ "_id" : ObjectId("5c6d7ad6f2db199c1278e7f0"), "Name" : "JOHN" }

Here is the query to make case insensitive query:

> db.caseInsensitiveDemo.find({"Name":/^john$/i});

The following is the output:

{ "_id" : ObjectId("5c6d7a67f2db199c1278e7ef"), "Name" : "John" }
{ "_id" : ObjectId("5c6d7ad6f2db199c1278e7f0"), "Name" : "JOHN" }
raja
Published on 18-Mar-2019 11:41:09
Advertisements