How do I make case-insensitive queries on Mongodb?

by

Chris Fulstow’s solution will work (+1), however, it may not be efficient, especially if your collection is very large. Non-rooted regular expressions (those not beginning with ^, which anchors the regular expression to the start of the string), and those using the i flag for case insensitivity will not use indexes, even if they exist.

An alternative option you might consider is to denormalize your data to store a lower-case version of the name field, for instance as name_lower. You can then query that efficiently (especially if it is indexed) for case-insensitive exact matches like:

db.collection.find({"name_lower": thename.toLowerCase()})

Or with a prefix match (a rooted regular expression) as:

db.collection.find( {"name_lower":
    { $regex: new RegExp("^" + thename.toLowerCase(), "i") } }
);

Both of these queries will use an index on name_lower.

More Related Contents:

  1. MongoDB Regex Search on Integer Value
  2. How can I use ‘Not Like’ operator in MongoDB
  3. MongoDB reverse regex
  4. MongoDB, performance of query by regular expression on indexed fields
  5. Mongodb match accented characters as underlying character
  6. Combining $regex and $or operators in Mongo
  7. Case insensitive search in Mongo
  8. Implement auto-complete feature using MongoDB search
  9. Is it possible to escape regex metacharacters reliably with sed
  10. Regex: match everything but a specific pattern
  11. bash regex with quotes?
  12. Regular expression for duplicate words
  13. Regular Expression for alphanumeric and underscores
  14. Why is a character class faster than alternation?
  15. Regex: Remove lines containing “help”, etc
  16. Mail::RFC822::Address Regex
  17. Regular Expressions- Match Anything
  18. How to Use/Enable (RegExp object) Regular Expression using VBA (MACRO) in word
  19. Remove .php from urls with htaccess
  20. Does lookbehind work in sed?
  21. Grammatical inference of regular expressions for given finite list of representative strings?
  22. Regex with replace in Golang
  23. Regex empty string or email
  24. Does \w match all alphanumeric characters defined in the Unicode standard?
  25. Invert match with regexp [duplicate]
  26. extract number after specific string
  27. Design DFA accepting binary strings divisible by a number ‘n’
  28. Regex matching beginning AND end strings
  29. Regex return file name, remove path and file extension
  30. Matching url with array list of words in AngularJS ui-router

Leave a Comment