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

mongodb case-insensitive
Luke Dennis picture Luke Dennis · Dec 7, 2009 · Viewed 281.3k times · Source

Example:

> db.stuff.save({"foo":"bar"});

> db.stuff.find({"foo":"bar"}).count();
1
> db.stuff.find({"foo":"BAR"}).count();
0

Answer

rfunduk picture rfunduk · Dec 7, 2009

You could use a regex.

In your example that would be:

db.stuff.find( { foo: /^bar$/i } );

I must say, though, maybe you could just downcase (or upcase) the value on the way in rather than incurring the extra cost every time you find it. Obviously this wont work for people's names and such, but maybe use-cases like tags.

Related questions

Case insensitive search in Mongo

I am using a case insensitive search in Mongo, something similar to https://stackoverflow.com/q/5500823/1028488. ie I am using a regex with options i. But I am am having trouble restricting the regex to just that word, its performs …

Read More
MongoDB and C#: Case insensitive search

I am using MongoDB and the C# driver for MongoDB. I recently discovered that all queries in MongoDB are case-sensitive. How can I make a case-insensitive search? I found one way to do this: Query.Matches( "FirstName", BsonRegularExpression.Create(new …

Read More
Querying MongoDB (via pymongo) in case insensitive efficiently

I'm currently creating a website in python (pyramid) which requires users to sign up and log in. The system allows for users to choose a username which can be a mixture of capital letters, lowercase letters, and numbers. The problem …

Read More