Case insensitive search in Mongo

by

You can Use $options => i for case insensitive search. Giving some possible examples required for string match.

Exact case insensitive string

db.collection.find({name:{'$regex' : '^string$', '$options' : 'i'}})

Contains string

db.collection.find({name:{'$regex' : 'string', '$options' : 'i'}})

Start with string

db.collection.find({name:{'$regex' : '^string', '$options' : 'i'}})

End with string

db.collection.find({name:{'$regex' : 'string$', '$options' : 'i'}})

Doesn’t Contains string

db.collection.find({name:{'$regex' : '^((?!string).)*$', '$options' : 'i'}})

Keep this as a bookmark, and a reference for any other alterations you may need.
http://www.cheatography.com/davechild/cheat-sheets/regular-expressions/

More Related Contents:

  1. Regular expression to match a line that doesn’t contain a word
  2. In regex, match either the end of the string or a specific character
  3. MongoDB Regex Search on Integer Value
  4. Escape function for regular expression or LIKE patterns
  5. Create new column in dataframe based on partial string matching other column
  6. How can I use ‘Not Like’ operator in MongoDB
  7. MongoDB reverse regex
  8. How do I make case-insensitive queries on Mongodb?
  9. MongoDB, performance of query by regular expression on indexed fields
  10. Mongodb match accented characters as underlying character
  11. Combining $regex and $or operators in Mongo
  12. notepad++ Inverse Regex replace (all but string)
  13. Implement auto-complete feature using MongoDB search
  14. Regular expression [ 1 ( 0 1* 0)* 1 ]* DFA
  15. subdomain htaccess rediect with query string
  16. Regex to pick characters outside of pair of quotes
  17. Find ‘word’ not followed by a certain character
  18. Regex to split a CSV
  19. How can I match nested brackets using regex?
  20. How do I grep for all non-ASCII characters?
  21. How to match Cyrillic characters with a regular expression
  22. Negative matching using grep (match lines that do not contain foo)
  23. Remove all special characters from a string in R?
  24. Regular expression for validating names and surnames?
  25. Matching all words except one
  26. HTML5 Form Input Pattern Currency Format
  27. How to pattern match using regular expression in Scala?
  28. Oracle REGEXP_LIKE and word boundaries
  29. US Phone Number Verification
  30. Swift 3 – How do I extract captured groups in regular expressions?

Leave a Comment