mongodb: query to check if item in an array contains a particular string [duplicate]

Question

I have a collection called products with the following items

[
  { 
    name: 'Product 1'
    images: ['http://staging.example.com/1', 'http://production.example.com/2'],
    ... 
  },
  { 
    name: 'Product 2'
    images: ['http://production.example.com/3'],
    ... 
  }
]

I want to find documents that contain string staging in the images array.

I tried couple of things like using $contains but mongo throws error saying I cannot use $contains with array.

Mạnh Quyết Nguyễn · Accepted Answer · 2018-05-24 14:45:47Z

3

I think you might need regex searching here.

Try:

db.collection.find({images: /staging/});

answered May 24, 2018 at 14:45

Mạnh Quyết Nguyễn

18.3k1 gold badge28 silver badges54 bronze badges

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

4 Comments

Madhusudhan Over a year ago

Ah! could have guessed that :) Thanks!

Mạnh Quyết Nguyễn Over a year ago

You're welcome~

Madhusudhan Over a year ago

Do you may be also know how to update staging to production using update? db.collection.update({images: /staging/}, { $set: { 'images.$[]': ? } })

Mạnh Quyết Nguyễn Over a year ago

staging is part of your string value. Update part of string is out of mongo's hand I think

Berhanu Tarekegn · Accepted Answer · 2018-05-24 14:58:00Z

0

db.products.find({images: /staging/i});

I think this will may help

answered May 24, 2018 at 14:58

Berhanu Tarekegn

3281 silver badge8 bronze badges

Collectives™ on Stack Overflow

mongodb: query to check if item in an array contains a particular string [duplicate]

2 Answers 2

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Linked

Related