regex find query not working when data is a url in mongodb

Question

I have a url field as:

db.test.insert({"url":"https://www.google.com/shopping/product/1/online?prds=pid:11247610123343072928,https://www.google.com/shopping/product/1/online?prds=pid:1124761012334307256565"})

but when I do

db.test.find({"url": {"$regex":"https://www.google.com/shopping/product/1/online?prds=pid:11247610123343072928"}})

It returns nothing. I want to find all documents that matches a substring. What am I doing wrong?

Jitendra · Accepted Answer · 2019-02-14 18:47:44Z

2

You just need to ignore special character and then your query will work. Try using query below:

db.test.find({"url": {"$regex":"https://www.google.com/shopping/product/1/online.*\\?.*prds=pid:11247610123343072928"}})

answered Feb 14, 2019 at 18:47

Jitendra

3,1953 gold badges31 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

regex find query not working when data is a url in mongodb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related