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

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" }

Krantik Chavan

Published on 18-Mar-2019 11:41:09

• Related Questions & Answers
• How to make a case-insensitive query in MongoDB?
• MongoDB query with case insensitive search?
• MongoDB query for specific case insensitive search
• Is it possible to cast in a MongoDB Query?
• How do I make case-insensitive queries on MongoDB?
• How to make jQuery attribute selector case insensitive?
• Is it possible to return a list of specific values from a MongoDB query?
• Is it possible to return a list of specific values from a query in MongoDB?
• How do I make my string comparison case insensitive?
• Is it possible to calculate a correlation in a MySQL query?
• Is it possible to achieve a slice chain in MongoDB?
• Is it possible to make an insert or an update in the same MySQL query?
• Is it possible to use MongoDB capped collection?
• MySQL case-insensitive DISTINCT?
• How do we make my string comparison case insensitive in java?