regex/collection equivalent of a like/subquery

I would like to do a $regex search against regex values in another collection. With SQL I would use a subquery and "like" - but I'm unsure if there is an equivalent structure/query to do something like this. I know this is not correct, but I'm picturing something like this - just not sure of the correct syntax - especially to indicate the specific column to do the regex against:

company: {
$in: [{
"$regex": {"collName":"SavedSearches", "include":"search",
"$options": "im"

where SavedSearches has 3 columns:
owner (user id - each user may have multiple saved searches)
search (string containing regex expression to search for)

_id owner search
5432e856e4b013192ec44d30 5278ef66e4b01085e4b79482 googl
54401e92e4b05c4ac3b7be7c 5278ef66e4b01085e4b79482 appl

So the query would return rows for companies including "Google" and "Apple" and "Snapple".

Is this possible? If not, I'm thinking I will have to store saved searches in an array and build the query on the fly using "$in array of $regex". But i would prefer to do a "subquery" style approach where I could potentially search for matches across multiple users using a job and pushnotification.

thanks in advance.
1 person has
this question
This topic is no longer open for comments or replies.