Mongo db query all documents contains substring matching in a given array of strings

Question

The title might be a little confusing, here is the data:

location_collection:

{name: "A"}
{name: "A1"}
{name: "B"}
{name: "B1"}
{name: "C"}
{name: "C1"}

my query:

 mongooseModel.find({ name: { $in: ['A', 'B'] } })

what I get:

{name: "A"}
{name: "B"}

What I want to get:

{name: "A"}
{name: "A1"}
{name: "B"}
{name: "B1"}

I try this but it doesnt work:

 mongooseModel.find({ name: { $in: [$substr:['A'], $substr:['B']] } })

Thanks in advance.

Indraraj26 · Accepted Answer · 2021-03-19 11:53:15Z

1

You can use $regex

db.collection.find({
  $or: [
    {
      name: {
        $regex: "A",
        
      }
    },
    {
      name: {
        $regex: "B",
        
      }
    }
  ]
})

Mongo playground: https://mongoplayground.net/p/BMV2oNDjp-1

answered Mar 19, 2021 at 11:53

Indraraj26

1,9941 gold badge17 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Mongo db query all documents contains substring matching in a given array of strings

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