MongoDB php: find when element is present inside array

Question

I have following document structure

{
  "_id":12638gkhF67JKGftyh88,
  "tags":[1,3,5,6,9]
}
.
.
.

I want to search search on the basis where _id matches and tags has value '6'

in PHP, my query will be like

$collection -> find(
  '$and' => array(
     array("_id" => new MongoId("12638gkhF67JKGftyh88")),
     array("tags" => WHAT WOULD BE HERE)
  )
)

I couldn't find anything about this, help me out plz

Sean Keane · Accepted Answer · 2014-08-22 18:43:41Z

1

Using the in operator

$collection -> find(
'$and' => array(
 array("_id" => new MongoId("12638gkhF67JKGftyh88")),
 array("tags" => array("$in" => "6"))
)
)

answered Aug 22, 2014 at 18:43

Sean Keane

4111 gold badge6 silver badges19 bronze badges

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

Comments

vodolaz095 · Accepted Answer · 2014-08-22 18:31:57Z

1

in mongodb there is an operator of in for searching values in arrays - http://docs.mongodb.org/manual/reference/operator/query/in/

answered Aug 22, 2014 at 18:31

vodolaz095

6,9944 gold badges30 silver badges42 bronze badges