Querying for an exact match but case insensitive

[AGarcia]

What is the recommended way(s) of creating a search query for an exact
match on a field but making it case insensitive.

Maybe something like this?

Query.Matches("Username", new
BsonRegularExpression("/^" + username + "$", "i"))

[Robert Stam]

That will work, but keep in mind that it can't use any indexes.

If you need to use an index, your best best is to store the field twice, with the second copy being all lower case, and then using a regular EQ search against that.

    Query.EQ("UsernameLowerCase", username.ToLower())

and it will use an index on UsernameLowerCase if one exists.

[Andres Garcia]

Thanks...   I was expecting that answer...

[Anoop Asokan]

Does it work if query contains '.' character?