Querying in MongoDB Compass

Question

Just a quick question I hope someone can answer for me.

I have a collection in MongoDB containing 84 thousand documents. The data looks something like this:

There are several thousand documents containing the word "BOND" as the category name such as this:

And many thousands more...

Currently in MongoDB Compass I am using the following query:

{ "Category" : "BOND" } 

But of course this just returns 1 document that where the Category is BOND.

Can anybody tell me how I can query to find all documents where the field name "Category" contains the word "BOND" within it?

Many thanks, G

Answer 1

You should use regexp for this, i.e.

{ "Category" : /^BOND.*/ } 

for categories begins with BOND, or

{ "Category" : /.*BOND.*/ } 

for categories contains BOND within