MongoDB Regex with multiple string having special character

Question

I have a problem in mongodb query. I have to fetch only those rows from table 'Feed' where field named 'message' having sub string 'you & me' or 'abc ? def'.

I am using following query but it is not working.

db.getCollection('Feed').find({"message": { "$regex" : 'you & me | abc ? def'}});

I got an alternate solution also for above by replacing all special character with its hexadecimal value like given below query.

db.getCollection('Feed').find({"message": { "$regex" : 'you \0x26 me | abc \0x3f def'}});

but in this case result is coming only for 'you \0x26 me' it means if i convert special character with hexadecimal value. it works only for first search regex.

Sede · Accepted Answer · 2015-10-13 13:20:15Z

2

You need to escape the & and ? in your regex because they are special character.

db.getCollection('Feed').find({ 'message': /\s*you \& me\s*|\s*abc \? def\s*/ })

Demo

edited Oct 13, 2015 at 13:20

answered Oct 13, 2015 at 12:48

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

2 Comments

ashish kumar gupta Over a year ago

In given link of demo, there is given in explanation that \s* matches any white space character. But in my case there may be any character before and after search keyword. what changes to be done for my requirement in the place of \s*.

Sede Over a year ago

it doesn't matter the regex will still work. just try it

Collectives™ on Stack Overflow

MongoDB Regex with multiple string having special character

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related