MongoDB - Use field in the document as regex expression

Question

I am storing regex expressions in MongoDB and would like to use them for queries.

Documents structure:

{
    "name": "foo",
    "regex_expression": "^[^@ ]+@(bar\\.com)$"
}

I tried the following query but it doesn't work.

db.collection.find({$expr: {$regex: ["[email protected]", "$regex_expression]}})

Is it possible to do this kind of query?

Yong Shun · Accepted Answer · 2022-09-02 12:33:51Z

1

You need the $regexMatch operator.

db.collection.find({
  $expr: {
    $regexMatch: {
      input: "[email protected]",
      regex: "$regex_expression"
    }
  }
})

answered Sep 2, 2022 at 12:33

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1