1 and or 使用
>db.col.find({$or:[{key1: value1}, {key2:value2}]})
2 where使用,和sql一样
查询已经有回款,但是没有完成回款的订单
>order
>db.info.find({
'$where': "this.price > this.received_money",status:2}).count()
3 条件操作符号
(>) 大于 - $gt
(<) 小于 - $lt
(>=) 大于等于 - $gte
(<= ) 小于等于 - $lte
db.col.find({likes : {$lt : 150}})
4 数组嵌套查询
>roster
>db.domain_set.find({})
{ "_id" : ObjectId("55cdb554b9518f0121a9870f"), "did" : NumberLong(75707), "hide_account" : 0, "pds" : { "details" : [ { "key" : "姓名", "type" : 0, "check" : 1 }, { "key" : "性别", "type" : 0, "check" : 1 }, { "key" : "联系方式", "type" : 0, "check" : 1 }, { "key" : "部门", "type" : 0, "check" : 1 }, { "key" : "职位", "type" : 0, "check" : 1 }, { "key" : "工号", "type" : 0 }, { "k