Regex working in mongodb commandline but not with mongoose

Question

I have a schema named Skills which has a single string field called name. I want to perform a search on the field based on a given string. For normal strings like java, its working fine. But, for C++, its omitting the ++ part as + is a special character in regex. So I replaced + with \\+ which is working fine in mongodb. To do this, following is my query in mongodb commandline which is giving me the required result:

db.skills.find({"name": {'$regex': '^c\\+\\+', '$options': 'i'}})

Following is my code with mongoose:

    word = '^' + req.query.word;
    word = word.replace(/\+/g, '\\+')
    word = word.replace(/\./g, '\\+')
    Skill.find({"name": {'$regex': word, '$options': 'i'}}).limit(10).exec(function (err, results) {
        res.json({'results': results})
    })

Here I have added the two replace statements to replace + with \\+ and . with \\.

But, the above code is not working. It's giving me zero result. Please help me if I am wrong somewhere.

Thanks,

@Ashish I did that only for both + and .. But, didn't work — amulya349
– amulya349, Commented May 25, 2018 at 8:47
My original code worked. Actually the bug was with different part of code. In the request only, it was coming as c insead of c++ because the browser was omitting the +. Fixed that issue. Thanks for your response. :) — amulya349
– amulya349, Commented May 25, 2018 at 8:57

Neil Lunn · Accepted Answer · 2018-05-25 08:50:08Z

2

let word = "c++";

Skill.find({ "name": RegExp("^" + word.replace(/\+/g,"\\+"),"i") })

or

Skill.find({ "name": { "$regex": "^" + word.replace(/\+/g,"\\+"), "$options": "i" } })

Both return the document without problem

answered May 25, 2018 at 8:50

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

1 Comment

amulya349 Over a year ago

Thanks for your answer. The code was fine. issue was with the request parameter where it was coming as c instead of c++. Browser was the culprit.

Collectives™ on Stack Overflow

Regex working in mongodb commandline but not with mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related