Menu
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...
777
In MongoDb, can use like using MongoDb reference operator regular expression(regex).
MongoDB provides the functionality to search a pattern in a string during a query by writing a regular expression. A regular expression is a generalized way to match patterns with sequences of characters. MongoDB uses Perl compatible regular expressions(PCRE) version 8.42 along with UTF-8 support.
Create a Wildcard Index on All Fields With this wildcard index, MongoDB indexes all fields for each document in the collection. If a given field is a nested document or array, the wildcard index recurses into the document/array and stores the value for all fields in the document/array.
To search a string with special characters in MongoDB document, you can use \. Here, we have special character $ in our string.
Try this one:
db.testlogwiki.find({"line_text" : new RegExp(result) };
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'] } } );
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
