PHP MongoDB Query into an array with an unknown key

Question

I have a mongoDB set up like so:

fieldName: {
  "1": {
      client: "name-here",
      subfield: "more-junk-here"
   },
   "2": {
      client: "another-client-name-here",
      subfield: "more-data"
   },
   "3": {
      client: "client-num-3",
      subfield: "i-like-turkey-sandwiches"
   }
}

How do I query for "i-like-turkey-sandwiches", without knowing it's in position 3, and without doing a search of the whole document? I started writing this, but am completely stumped how to do the search...

$cursor = $collection->findOne(array('fieldName' => 'i-like-turkey-sandwiches));

Aurélien B · Accepted Answer · 2012-10-17 13:56:39Z

1

(edit: My answer is valid only if fieldName content is an array of subdocument and not a document with "1"/2/3 as key and subdocument as value)

If you query with

$cursor = $collection->findOne(
              array('fieldName.subfield' => 'i-like-turkey-sandwiches'));

It will return you all documents where you have a subfield inside a fieldName field with this value.

edited Oct 17, 2012 at 13:56

answered Oct 17, 2012 at 13:41

Aurélien B

4,6403 gold badges37 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

PHP MongoDB Query into an array with an unknown key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related