mongoDb ignore Capital

Question

I'd like to set a mongoDb request ignoring capitals

If I only have one user with test username

db.users.find(
    { username: "test" }
)

will return something I'd like to return the profile test with

db.users.find(
    { username: "Test" }
)

or

db.users.find(
    { username: "tEsT" }
)

But I don"t know I to ignore capitals

same problem if I have a username Toby I'd like to find with

db.users.find(
    { username: "toby" }
)

Thanks

Seems to be a duplicate, rich answers could be found there: http://stackoverflow.com/questions/1863399/mongodb-is-it-possible-to-make-a-case-insensitive-query — udalmik, Nov 20 '12 at 14:02

score 2 · Accepted Answer · answered Nov 20 '12 at 13:46

You can use regex to ignore capitals like:

db.users.find({username: /test/i})

Whereby the i option state case insensitive. This however is not very index friendly.

A better option is to do this client side. Normalise your case so that everything is either lower case or upper case. That way you can just test as normal.

mongoDb ignore Capital

1 Answers1