MongoDB - 简单查询

AND

db.col.find({key1:value1, key2:value2}).pretty()

 

OR

db.col.find( { $or: [      {key1: value1}, {key2:value2} ] } ).pretty()

 

AND OR

db.col.find( {

key: {$gt:value}, $or: [      {key1: value1}, {key2:value2} ] } ).pretty()

 

比较

等于：{<key>:<value>}，db.col.find({"by":"菜鸟教程"}).pretty()

小于：{<key>:{$lt:<value>}}，db.col.find({"likes":{$lt:50}}).pretty()

小于等于：{<key>:{$lte:<value>}}，db.col.find({"likes":{$lte:50}}).pretty()

大于：{<key>:{$gt:<value>}}，db.col.find({"likes":{$gt:50}}).pretty()

大于等于：{<key>:{$gte:<value>}}，db.col.find({"likes":{$gte:50}}).pretty()

不等于：{<key>:{$ne:<value>}}，db.col.find({"likes":{$ne:50}}).pretty()

 

 

Limit skip

db.COLLECTION_NAME.find().limit(NUMBER)

db.COLLECTION_NAME.find().limit(NUMBER).skip(NUMBER)

 

 

sort()

db.COLLECTION_NAME.find().sort({KEY:1})

db.COLLECTION_NAME.find().sort({KEY:-1})