一、find查询

1、find查询全部

> db.test.find(){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007742"), "name" : "whc10", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007743"), "name" : "whc11", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007744"), "name" : "whc12", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007745"), "name" : "whc13", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007746"), "name" : "whc14", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007747"), "name" : "whc15", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007748"), "name" : "whc16", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007749"), "name" : "whc17", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774a"), "name" : "whc18", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774b"), "name" : "whc19", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

2、 find带条件查询

> db.test.find({"count":20}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

3、findOne()查询一条

> db.test.findOne(){	"_id" : ObjectId("588703baab6c3f09f0007738"),	"name" : "whc0",	"type" : 1,	"count" : 20,	"geoloc" : {		"lat" : 39.16193771362305,		"lng" : 117.13493347167969	}}

4、findOne()查询满足条件一条

> db.test.findOne({"name":"whc9"}){	"_id" : ObjectId("588703baab6c3f09f0007741"),	"name" : "whc9",	"type" : 1,	"count" : 20,	"geoloc" : {		"lat" : 39.16193771362305,		"lng" : 117.13493347167969	}}

5、指定需要(或不需要)返回的键

> db.test.find({"name":"whc0"},{"name":1,"type":1}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1 }>> db.test.find({"name":"whc0"},{"name":0,"type":0}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

二、查询条件

1、范围查询("$lt"、"$lte"、"$gt"、"$gte"、"$ne"，分别对应<、<=、>、>=、!=。可以使用这些比较操作符组合起来查找一个范围的值)。

> db.test.find({"type":{"$lte":2},"count":{"$gte":20}}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

2、OR查询

有两种方式可以进行OR查询："$in"可以用来查询一个键的多个值，"$or"更通用一些，可以在多个键中查询任意的给定值

"$in"查询

> db.test.find({"name":{"$in":["whc0","whc1","whc2"]}}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

"$or"查询

> db.test.find({"$or":[{"name":"whc10"},{"count":20}]}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007742"), "name" : "whc10", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }

三、特定类型的查询

1、对值的null进行查询

> db.test.find(){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20 }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007742"), "name" : "whc10", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007743"), "name" : "whc11", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007744"), "name" : "whc12", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007745"), "name" : "whc13", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007746"), "name" : "whc14", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007747"), "name" : "whc15", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007748"), "name" : "whc16", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007749"), "name" : "whc17", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774a"), "name" : "whc18", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774b"), "name" : "whc19", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }Type "it" for more>>> db.test.find({"geoloc":null}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 20 }>>> db.test.find({"geoloc":{"$in":[null],"$exists":true}}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : null }

2、利用正则表达式进行查询

> db.test.find({"name":"whc0"}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : null }>> db.test.find({"name":/whc0/i}){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 20, "geoloc" : null }>> db.test.find({"name":/whc.{5}/i}){ "_id" : ObjectId("588703c0ab6c3f09f0009e48"), "name" : "whc10000", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e49"), "name" : "whc10001", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4a"), "name" : "whc10002", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4b"), "name" : "whc10003", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4c"), "name" : "whc10004", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4d"), "name" : "whc10005", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4e"), "name" : "whc10006", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e4f"), "name" : "whc10007", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e50"), "name" : "whc10008", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e51"), "name" : "whc10009", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e52"), "name" : "whc10010", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e53"), "name" : "whc10011", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e54"), "name" : "whc10012", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e55"), "name" : "whc10013", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e56"), "name" : "whc10014", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e57"), "name" : "whc10015", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e58"), "name" : "whc10016", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e59"), "name" : "whc10017", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e5a"), "name" : "whc10018", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703c0ab6c3f09f0009e5b"), "name" : "whc10019", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }Type "it" for more

五、游标

1、使用游标

> db.test.find(){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 26, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 25 }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 24, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 23, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 22, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 21, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 19, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 18, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 17, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007742"), "name" : "whc10", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007743"), "name" : "whc11", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007744"), "name" : "whc12", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007745"), "name" : "whc13", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007746"), "name" : "whc14", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007747"), "name" : "whc15", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007748"), "name" : "whc16", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007749"), "name" : "whc17", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774a"), "name" : "whc18", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774b"), "name" : "whc19", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }Type "it" for more>>> var i=0; var cursor=db.test.find();>> while(cursor.hasNext() && i<10) {var obj=cursor.next(); print("current obj is "+obj.name); i++}current obj is whc0current obj is whc1current obj is whc2current obj is whc3current obj is whc4current obj is whc5current obj is whc6current obj is whc7current obj is whc8current obj is whc99>

2、limit、sort和skip（这三者混合使用，顺序并不影响最终结果）

> db.test.find(){ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 23, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f0007739"), "name" : "whc1", "type" : 1, "count" : 25 }{ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 24, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773b"), "name" : "whc3", "type" : 1, "count" : 26, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 22, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 21, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773f"), "name" : "whc7", "type" : 1, "count" : 19, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007740"), "name" : "whc8", "type" : 1, "count" : 18, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007741"), "name" : "whc9", "type" : 1, "count" : 17, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007742"), "name" : "whc10", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007743"), "name" : "whc11", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007744"), "name" : "whc12", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007745"), "name" : "whc13", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007746"), "name" : "whc14", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007747"), "name" : "whc15", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007748"), "name" : "whc16", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007749"), "name" : "whc17", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774a"), "name" : "whc18", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000774b"), "name" : "whc19", "type" : 1, "count" : 16, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }Type "it" for more>>> db.test.find().skip(2).sort({"count":-1}).limit(5){ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 24, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 23, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 22, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 21, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }>>> db.test.find().sort({"count":-1}).skip(2).limit(5){ "_id" : ObjectId("588703baab6c3f09f000773a"), "name" : "whc2", "type" : 1, "count" : 24, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f0007738"), "name" : "whc0", "type" : 1, "count" : 23, "geoloc" : null }{ "_id" : ObjectId("588703baab6c3f09f000773c"), "name" : "whc4", "type" : 1, "count" : 22, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773d"), "name" : "whc5", "type" : 1, "count" : 21, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }{ "_id" : ObjectId("588703baab6c3f09f000773e"), "name" : "whc6", "type" : 1, "count" : 20, "geoloc" : { "lat" : 39.16193771362305, "lng" : 117.13493347167969 } }