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

Question

Example:

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

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

1 

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

0

Answer 1

Yes, it is possible to make a case-insensitive query for that you can use a regex.

Example code for that is as follows:-

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