Mongo Query with Regex in Node JS operating ON A VARIABLE

Question

Mongo Query with Regex in Node JS operating ON A VARIABLE

I have a problem here. I want to query my MongoDB in my Node JS file using something like LIKE for a conventional relational db. The problem is the thing I want to LIKE to is not a literal...it is a variable! I have found no good way to do this as of yet. Here was the "durrr first try" shot I took at it:

var result = postData.replace(/\+/g,' ').substring(5);
db.testlogwiki.find({"line_text" : /result/ };
//predictably only matches to the literal "result" as opposed to my variable

testlogwiki is made in Mongo...I have it running and this does mach to db entries with "line_text" containing "result" literally.

It seems like a very simple question...

node.js
mongodb

Answer 1

Try this one:

db.testlogwiki.find({"line_text" : new RegExp(result) };

Answer 2

You can also use the $regex option.

db.testlogwiki.find( { line_text: { $regex: result[, $options: 'i'] } } );

Answer 3

Both will work

db.testlogwiki.find({"line_text" : new RegExp(result, 'i') }; // to make this case insensitive

or

db.testlogwiki.find( { line_text: { $regex: result[, $options: 'i'] } } );