Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{_id:1,color:["red","green","yellow"]},{_id:2,color:["red","blue","orange"]},{_id:3,color:["blue","black","grey"]}]
Query
db.collection.find({$expr:{$gt:[{$size:{$setIntersection:[["red"],"$color"]}},0]}})
Result