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?