MongoDB - matching an array of string elements to single string element in a document

Question

I'm using MongoDB v3.6.5

I have a collection called "dealers" that hold documents which look like following examples below.

{
_id: 1
country: "France"
}

{
_id: 2
country: "Belgium"
}

I have an array of country values such as;

["France","Germany","Belgium"]

I want to retrieve all documents from dealers collection where it matches values between "country" property and array values.

score 1 · Accepted Answer · edited Dec 11 '19 at 02:50

1

Use the $in operator.

db.dealers.find( { "country" : { $in : [ "France", "Belgium" ] } } )

edited Dec 11 '19 at 02:50

Ashh

answered Dec 10 '19 at 20:01

Victor Wilson

1 Answers1