collection數(shù)據(jù)準(zhǔn)備
use wygzs
db.myuser.insert( {name:”shijiange1″, age: 20} )
db.myuser.insert( {name:”shijiange2″, age: 28} )
db.myuser.insert( {name:”shijiange3″, age: 38} )
db.myuser.insert( {name:”zhangsan1″, age: 58} )
db.myuser.insert( {name:”zhangsan2″, age: 68} )
db.myuser.insert( {name:”zhangsan3″, age: 25} )
db.myuser.insert( {name:”shijiange1″, age: 20} )
ert( {name:”zhangsan3″, age: 25} )WriteResult({ “nInserted” : 1 })
db.myuser.insert( {name:”shijiange2″, age: 28} )
WriteResult({ “nInserted” : 1 })
db.myuser.insert( {name:”shijiange3″, age: 38} )
WriteResult({ “nInserted” : 1 })
db.myuser.insert( {name:”zhangsan1″, age: 58} )
WriteResult({ “nInserted” : 1 })
db.myuser.insert( {name:”zhangsan2″, age: 68} )
WriteResult({ “nInserted” : 1 })
db.myuser.insert( {name:”zhangsan3″, age: 25} )
WriteResult({ “nInserted” : 1 })

pretty易讀的方式
db.myuser.find().pretty()
db.myuser.find().pretty()
{
“_id” : ObjectId(“6362360295502fbd56836b96”),
“name” : “shijiange1”,
“age” : 20
}
{
“_id” : ObjectId(“6362360295502fbd56836b97”),
“name” : “shijiange2”,
“age” : 28
}
{
“_id” : ObjectId(“6362360295502fbd56836b98”),
“name” : “shijiange3”,
“age” : 38
}
{
“_id” : ObjectId(“6362360295502fbd56836b99”),
“name” : “zhangsan1”,
“age” : 58
}
{
“_id” : ObjectId(“6362360295502fbd56836b9a”),
“name” : “zhangsan2”,
“age” : 68
}
{
“_id” : ObjectId(“6362360295502fbd56836b9b”),
“name” : “zhangsan3”,
“age” : 25
}

limit限制條數(shù)查詢
db.myuser.find()
db.myuser.find().limit(2) #查看前面兩條記錄
db.myuser.find().limit(2)
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
db.myuser.find().limit(2).pretty()
{
“_id” : ObjectId(“6362360295502fbd56836b96”),
“name” : “shijiange1”,
“age” : 20
}
{
“_id” : ObjectId(“6362360295502fbd56836b97”),
“name” : “shijiange2”,
“age” : 28
}

使用skip跳過(guò)記錄
db.myuser.find().skip(2).limit(2)
db.myuser.find().skip(2)
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
{ “_id” : ObjectId(“6362360295502fbd56836b99”), “name” : “zhangsan1”, “age” : 58 }
{ “_id” : ObjectId(“6362360295502fbd56836b9a”), “name” : “zhangsan2”, “age” : 68 }
{ “_id” : ObjectId(“6362360295502fbd56836b9b”), “name” : “zhangsan3”, “age” : 25 }
db.myuser.find().skip(2).limit(2)
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
{ “_id” : ObjectId(“6362360295502fbd56836b99”), “name” : “zhangsan1”, “age” : 58 }

mongodb分頁(yè)查詢
db.myuser.find().skip(0).limit(2)
db.myuser.find().skip(2).limit(2)
db.myuser.find().skip(4).limit(2)

使用sort進(jìn)行排序
db.myuser.find().sort({ age: 1 })#按age升序
db.myuser.find().sort({ age: -1 })#按age降序
db.myuser.find().sort({age:1})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b9b”), “name” : “zhangsan3”, “age” : 25 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
{ “_id” : ObjectId(“6362360295502fbd56836b99”), “name” : “zhangsan1”, “age” : 58 }
{ “_id” : ObjectId(“6362360295502fbd56836b9a”), “name” : “zhangsan2”, “age” : 68 }
db.myuser.find().sort({age:-1})
{ “_id” : ObjectId(“6362360295502fbd56836b9a”), “name” : “zhangsan2”, “age” : 68 }
{ “_id” : ObjectId(“6362360295502fbd56836b99”), “name” : “zhangsan1”, “age” : 58 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b9b”), “name” : “zhangsan3”, “age” : 25 }
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }

根據(jù)字段進(jìn)行數(shù)字比較查詢
db.myuser.find({ age: {$lt: 30} })
$gt#大于
$lt#小于
$gte#大于或等于
$lte#小于或等于
$eq #等于
db.myuser.find({age:{$lt:30}})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b9b”), “name” : “zhangsan3”, “age” : 25 }
db.myuser.find({age:{$gt:30}})
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
{ “_id” : ObjectId(“6362360295502fbd56836b99”), “name” : “zhangsan1”, “age” : 58 }
{ “_id” : ObjectId(“6362360295502fbd56836b9a”), “name” : “zhangsan2”, “age” : 68 }
db.myuser.find({age:{$eq:38}})
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }

查詢多種條件的組合
db.myuser.find( {name: ‘shijiange1’} )
db.myuser.find( {name: ‘shijiange2’} )
db.myuser.find({ $or: [ {name: ‘shijiange1’},{name: ‘shijiange2’} ] })
db.myuser.find({ $and: [ {name: ‘shijiange1’},{age: 20} ] })
db.myuser.find({$or:[{‘name’:’shijiange1′},{‘name’:’shijian2′}]})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
db.myuser.find({$or:[{‘name’:’shijiange1′},{age: 20}]})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }

mongodb正則查詢，支持普通正則和擴(kuò)展正則
db.myuser.find({ name: {$regex: “shijiange[1-9]”} })#普通正則過(guò)濾
db.myuser.find( {“name”:{$regex:”(zhangsan)”}} ) #支持分組正則
db.myuser.find({ name: {$regex: “shijiange[1-9]”} })
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
db.myuser.find({ name: {$regex: “shijiange[2-9]”} })
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
db.myuser.find({name: {$regex: “shijiange[2-9]”}})
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
db.myuser.find({name: {$regex: “(shijiange)”}})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
db.myuser.find({name: {$regex: “(shijiange+)”}})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }
{ “_id” : ObjectId(“6362360295502fbd56836b98”), “name” : “shijiange3”, “age” : 38 }
db.myuser.find({name: {$regex: “(shijiange+1)”}})
{ “_id” : ObjectId(“6362360295502fbd56836b96”), “name” : “shijiange1”, “age” : 20 }
db.myuser.find({name: {$regex: “(shijiange+2)”}})
{ “_id” : ObjectId(“6362360295502fbd56836b97”), “name” : “shijiange2”, “age” : 28 }