I am looking for a way to search for a keyword (ex. "Henrik") in the "answers" array of documents with the following structure
Array
(
[_id] => MongoId Object
(
[$id] => 4eeedd9545c717620a000007
)
[formId] => 6
[respId] => 4eeedd95c93228
[dateCreated] => 2011-10-14 07:45
[answers] => Array
(
[field1] => Henrik
[field6] => [email protected]
[field7] => my city address
)
)
I am working in PHP on this project, and quering like this works of course:
$answers = $collection->find( array('formId' => 6, 'answers.field1'=> 'Henrik' ) );
What I want to do is search without a specific key of the answers array, like this
$answers = $collection->find( array('formId' => 6, 'answers'=> 'Henrik' ) );
Is it possible to do this type of query? I am sorry if this is a repost. I was not able to find any examples about this here or on Google.
$answers = $collection->find( array('formId' => 6,
'answers'=>
array('$in' => array('Henrik'))));
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With