查询

 准备：添加数据

> db.media.insert({"Type":"Book","Title":"Definitive Guide to MongoDB 3rd","ISSBN":"978-1-4842-1183","Publisher":"Appress","Author":["Hows","Plugge","Membrey","Hawkins"]})

> db.media.insert({"Type":"CD","Artist":"Nirvana","Title":"Nevermind","Tracklist":[{"Track":"1","Title":"smells like spirit","length":"5:02"},{"Track":"2","Title":"In Bllom","length":"4:15"}]})

> db.media.find()
{ "_id" : ObjectId("5ebb50ba6f3a777cf24a5920"), "Type" : "Book", "Title" : "Definitive Guide to MongoDB 3rd", "ISSBN" : "978-1-4842-1183", "Publisher" : "Appress", "Author" : [ "Hows", "Plugge", "Membrey", "Hawkins" ] }
{ "_id" : ObjectId("5ebb513e6f3a777cf24a5921"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [   {       "Track" : "1",  "Title" : "smells like spirit",    "length" : "5:02" },    {       "Track" : "2",  "Title" : "In Bllom",      "length" : "4:15" } ] }

> db.media.insert({"Type":"DVD","Title":"Blade Runner","Released":1982})
> db.media.find()
{ "_id" : ObjectId("5ebb50ba6f3a777cf24a5920"), "Type" : "Book", "Title" : "Definitive Guide to MongoDB 3rd", "ISSBN" : "978-1-4842-1183", "Publisher" : "Appress", "Author" : [ "Hows", "Plugge", "Membrey", "Hawkins" ] }
{ "_id" : ObjectId("5ebb513e6f3a777cf24a5921"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [   {       "Track" : "1",  "Title" : "smells like spirit",    "length" : "5:02" },    {       "Track" : "2",  "Title" : "In Bllom",      "length" : "4:15" } ] }
{ "_id" : ObjectId("5ebb518a6f3a777cf24a5922"), "Type" : "DVD", "Title" : "Blade Runner", "Released" : 1982 }

1 查询指定条件的文档

> db.media.find({Artist:"Nirvana"})
{ "_id" : ObjectId("5ebb513e6f3a777cf24a5921"), "Type" : "CD", "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [   {       "Track" : "1",  "Title" : "smells like spirit",    "length" : "5:02" },    {       "Track" : "2",  "Title" : "In Bllom",      "length" : "4:15" } ] }

2find()函数第二个参数：

1：除此字段显示，其他字段全都不显示

0：除此字段不显示，其他字段全都显示

> db.media.find({Artist:"Nirvana"},{"Title":1})
{ "_id" : ObjectId("5ebb513e6f3a777cf24a5921"), "Title" : "Nevermind" }
> db.media.find({Artist:"Nirvana"},{"Type":0})
{ "_id" : ObjectId("5ebb513e6f3a777cf24a5921"), "Artist" : "Nirvana", "Title" : "Nevermind", "Tracklist" : [       {
        "Track" : "1",  "Title" : "smells like spirit",
        "length" : "5:02" },    {       "Track" : "2",  "Title" : "In Bllom",      "length" : "4:15" } ] }

添加数据

> db.media.insert({"Type":"DVD","Title":"Matrix","Released":1999,"Cast":["Carrie","Laurence","Huge","Joe","Foster"]},{"Type":"DVD","Title":"Toy Story3","Released":2010})

3查询条件：大于小于

> db.media.find({Released:{$gt:2000}})
> db.media.find({Released:{$gt:1990}})
{ "_id" : ObjectId("5ebb52616f3a777cf24a5923"), "Type" : "DVD", "Title" : "Matrix", "Released" : 1999, "Cast" : [ "Carrie", "Laurence", "Huge", "Joe", "Foster" ] }
> db.media.find({Released:{$lt:1990}})
{ "_id" : ObjectId("5ebb518a6f3a777cf24a5922"), "Type" : "DVD", "Title" : "Blade Runner", "Released" : 1982 }
> db.media.find({Released:{$gte:1999}})
{ "_id" : ObjectId("5ebb52616f3a777cf24a5923"), "Type" : "DVD", "Title" : "Matrix", "Released" : 1999, "Cast" : [ "Carrie", "Laurence", "Huge", "Joe", "Foster" ] }
> db.media.find({Released:{$lte:1982}})
{ "_id" : ObjectId("5ebb518a6f3a777cf24a5922"), "Type" : "DVD", "Title" : "Blade Runner", "Released" : 1982 }

> db.media.find({Released:{$gte:1982,$lte:1999}})
{ "_id" : ObjectId("5ebb518a6f3a777cf24a5922"), "Type" : "DVD", "Title" : "Blade Runner", "Released" : 1982 }
{ "_id" : ObjectId("5ebb52616f3a777cf24a5923"), "Type" : "DVD", "Title" : "Matrix", "Released" : 1999, "Cast" : [ "Carrie", "Laurence", "Huge", "Joe", "Foster" ] }

4 $in,$nin

> db.media.find({Released:{$in:[1999,1982]}})
{ "_id" : ObjectId("5ebb518a6f3a777cf24a5922"), "Type" : "DVD", "Title" : "Blade Runner", "Released" : 1982 }

5 $all

6 $or