MongoDB reverse regex

Question

I have a document in MongoDB with a regex attribute ``` { _id: ObjectId("516023189732da20ce000004"), regex: /^(my|your)\s+regex$/ } ``` and I need to retrieve this document with something like `db.col.find({regex: 'your regex'})` and `db.col.find({regex: 'my regex'})`. In MySQL I'd do: `SELECT * FROM table WHERE 'my regex' REGEXP table.regex`. How can I achieve this in MongoDB?

Accepted Answer

You can use the $where operator in the following fashion:

```
db.col.find({$where: "\"my regex\".match(this.regex)"})
```

MongoDB reverse regex

Solution

Problem