Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{"id":1234,"close":"11100","products":[{"productId":111}]},{"id":1235,"close":"10101","products":[{"productId":111}]}]
Query
db.collection.aggregate([{$match:{$expr:{$eq:[{"$substr":["$close",1,1]},"0"]}}}])
Result