How to query a MongoDB collection with a regex?

Question

I am trying to query a collection and want to do it on just the beginning of the postal code. I've tried following the instructions but get 0 documents:

> db.listings.count({"house.postalcode" :  "EH21 8RG"})
2
> db.listings.count({"house.postalcode" :  {"$regex" : "/^EH21/"}})
0

I know I must be missing something but I've checked the regex online and you can see the results above of the two queries.. help!

When using $regex remove either remove string quotes (to make it a regex expression) and use : {"$regex" : /^EH21/} or use the string quotes without the forward slashes: {"$regex" : "^EH21"} docs — ambianBeing
– ambianBeing, Commented Aug 14, 2020 at 9:25

Rudey · Accepted Answer · 2020-08-14 09:18:24Z

1

It probably depends on what driver/library you use, but this works for me:

db.listings.count({ "house.postalcode": /^EH21/ })

edited Aug 14, 2020 at 9:18

answered Aug 14, 2020 at 9:15

Rudey

5,0255 gold badges47 silver badges89 bronze badges

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

1 Comment

Johnny John Boy Over a year ago

Thank you, thank you! :-) > db.listings.count({"house.postal_code" : /^EH21/}) 471

Collectives™ on Stack Overflow

How to query a MongoDB collection with a regex?

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