Mongodb Query contains # char

Question

How can i use $regex for matching any string contains '#'. Unlike other characters, # seems to be acting differently.

{"id" : {$regex : "what should go here"}}

does match strings that does not contains # as well. I was trying with .*\\#.* kind of regex.

and what you tried instead of "what should go here"? what you get, and what expected? — 2oppin, Dec 29 '17 at 08:10

score 1 · Answer 1 · answered Dec 29 '17 at 08:24

1

Something like:

{"id" : {$regex : /^.*#.*/ }}

And for NOT contains:

{"id" : {$not : /^.*#.*/ }}

See the docs

answered Dec 29 '17 at 08:24

Dabbas

score 1 · Answer 2 · answered Dec 29 '17 at 08:29

1

Found out that it should be like this.

 {"id" : {$regex : /\#/i}}

answered Dec 29 '17 at 08:29

aravindaM

From the documentation, https://docs.mongodb.com/manual/reference/operator/query/regex/#perform-case-insensitive-regular-expression-match – aravindaM Dec 29 '17 at 08:38

2 Answers2