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

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.

score 2 · Accepted Answer · answered May 24 '18 at 14:45

2

I think you might need regex searching here.

Try:

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

answered May 24 '18 at 14:45

Mạnh Quyết Nguyễn

17,677
1
23
51

Ah! could have guessed that :) Thanks! – Madhusudhan May 24 '18 at 15:10
You're welcome~ – Mạnh Quyết Nguyễn May 24 '18 at 15:14
Do you may be also know how to update `staging` to `production` using update? `db.collection.update({images: /staging/}, { $set: { 'images.$[]': ? } })` – Madhusudhan May 24 '18 at 15:49
`staging` is part of your string value. Update part of string is out of mongo's hand I think – Mạnh Quyết Nguyễn May 24 '18 at 16:00

score 0 · Answer 2 · answered May 24 '18 at 14:58

0

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

I think this will may help

answered May 24 '18 at 14:58

Berhanu Tarekegn

330
1
8

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

2 Answers2