Array(
[id] => 00008
[game] => Array
(
[0] => Array
(
[gid] => 02569
[date] => 1363583244
)
[1] => Array
(
[gid] => 04001
[date] => 1363339740
)
)
)
Array(
[id] => 00010
[game] => Array
(
[0] => Array
(
[gid] => 02569
[date] => 1363583244
)
[1] => Array
(
[gid] => 04028
[date] => 1363889740
)
)
)
The above are two of the many results. My current requirement is to find gid = 02569 from all the results and sort them by DESC according to the corresponding date
This is achieved by using the aggregate framework (for reference only, not tested). Mongodb 2.2+ is available.
db.xxx.aggregate([ { $match: {'game.gid': 02569} }, { $sort: {$date: -1} } ])