Combining $regex and $or operators in Mongo

by

The $or operator expects whole conditions so the correct form would be:

db.users.find({ "$or": [
    { "name": { "$regex": "^Da"} }, 
    { "name": { "$regex": "^Ali" }}
]})

Or of course using $in:

db.users.find({ "name": { "$in": [/^Da/,/^Ali/] } })

But it’s a regex so you can do:

db.users.find({ "name": { "$regex": "^Da|^Ali" } })

More Related Contents:

  1. MongoDB Regex Search on Integer Value
  2. How can I use ‘Not Like’ operator in MongoDB
  3. MongoDB, performance of query by regular expression on indexed fields
  4. MongoDB reverse regex
  5. How do I make case-insensitive queries on Mongodb?
  6. Mongodb match accented characters as underlying character
  7. Case insensitive search in Mongo
  8. Implement auto-complete feature using MongoDB search
  9. Regex lookahead, lookbehind and atomic groups
  10. How to match multiple occurrences of a substring
  11. Find and kill a process in one line using bash and regex
  12. Regular expression to match standard 10 digit phone number
  13. Regex: matching up to the first occurrence of a character
  14. Convert a char to upper case using regular expressions (EditPad Pro)
  15. How to check if a line is blank using regex
  16. What is the complexity of regular expression?
  17. MongoDB aggregation comparison: group(), $group and MapReduce
  18. Regular Expressions with repeated characters
  19. Multiple Counts with single query in mongodb
  20. Why do ^ and $ not work as expected?
  21. Is there an online RegexBuddy-like regular expression analyzer? [closed]
  22. Regular Expression Match to test for a valid year
  23. Searching for all variations of hyphens and dashes in Regex
  24. How do I remove all non-ASCII characters with regex and Notepad++?
  25. Google Sheets Formula for Extracting Domain From Website?
  26. Matching an optional substring in a regex
  27. How do I rename fields when performing search/projection in MongoDB?
  28. Replace string only once with php preg_replace
  29. Mongodb concat int and string
  30. Extracting text after last period in string [duplicate]

Leave a Comment