Mongo Query with Regex in Node JS operating ON A VARIABLE

Question

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...

Sergio Tulentsev · Accepted Answer · 2012-05-23 21:24:43Z

38

Try this one:

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

answered May 23, 2012 at 21:24

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

PinkElephantsOnParade Over a year ago

You're a saint. Will accept this when I get home (I have a time in which I cannot accept).

John Culviner Over a year ago

Hope your variable doesn't have any regex special characters in it or this will fail!

Lance Roberts · Accepted Answer · 2015-01-23 19:24:29Z

5

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'] } } );

edited Jan 23, 2015 at 19:24

Lance Roberts

22.9k32 gold badges115 silver badges132 bronze badges

answered Jan 23, 2015 at 19:04

Tridib

491 silver badge1 bronze badge

Comments

John Culviner · Accepted Answer · 2017-06-15 14:28:03Z

4

All of the other answers may fail depending on your input variable

You can use RegExp as others have indicated but you must escape special regex characters or else this can fail.

Lodash has a function to do this (if you aren't using it you probably should be, it adds a lot of sugar that isn't even in the ES6+ spec)

https://lodash.com/docs#escapeRegExp

db.COLLECTION.find({FIELD_NAME: new RegExp(_.escapeRegExp(VAR), 'i') };

answered Jun 15, 2017 at 14:28

John Culviner

23.1k6 gold badges59 silver badges53 bronze badges

Comments

az_ · Accepted Answer · 2013-02-19 00:03:26Z

2

You can also use the $regex option.

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

answered Feb 19, 2013 at 0:03

az_

1,5032 gold badges18 silver badges25 bronze badges

Collectives™ on Stack Overflow

Mongo Query with Regex in Node JS operating ON A VARIABLE

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related