PHP MongoDB Search in Sub-array

Question

Data stored in collection as below

 [field_1] => Array
                (
                    [fields] => Array
                        (
                            [0] => MongoInt64 Object
                                (
                                    [value] => 1233
                                )

                            [1] => MongoInt64 Object
                                (
                                    [value] => 1234
                                )

                        )

                )

I need to search 1234 in field.

I used below code in php to search

$param = array('field_1.fields.$' => 1234);

But this is not working

luishdez · Accepted Answer · 2016-02-19 22:34:58Z

3

You need to use the $in query criteria, to find elements within an array

$cursor = $collection->find(array("field_1.fields" => array('$in' => array("1234"))));

This will find all items that have 1234 within "fields"

$in doc: https://docs.mongodb.org/v3.0/reference/operator/query/in/

answered Feb 19, 2016 at 22:34

luishdez

1861 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

PHP MongoDB Search in Sub-array

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