mongo数据库的各种查询语句示例

11、db.users.find() 
2  -- db.getCollection('users').find({})
3  -- select * from users
4  
52、db.users.find({"age" : 27}) 
6  -- select * from users where age = 27  
73、db.users.find({"username" : "joe", "age" : 27}) 
8  -- select * from users where "username" = "joe" and age = 27  
9
104、db.users.find({}, {"username" : 1, "email" : 1}) 
11  -- select username, email from users  
125、db.users.find({}, {"username" : 1, "_id" : 0}) 
13  -- no case  
14  -- 即时加上了列筛选，_id也会返回，必须显式的阻止_id返回
15
166、db.users.find({"age" : {"$gte" : 18, "$lte" : 30}}) 
17  -- select * from users where age >=18 and age <= 30 
18  -- $lt(<) $lte(<=) $gt(>) $gte(>=)  
197、db.users.find({"username" : {"$ne" : "joe"}}) 
20  -- select * from users where username != "joe"  
21
228、db.users.find({"ticket_no" : {"$in" : [725, 542, 390]}}) 
23  -- select * from users where ticket_no in (725, 542, 390)  
249、db.users.find({"ticket_no" : {"$nin" : [725, 542, 390]}}) 
25  -- select * from users where ticket_no not in (725, 542, 390)  
26
2710、db.users.find({"$or" : [{"ticket_no" : 725}, {"winner" : true}]}) 
28  -- select * form users where ticket_no = 725 or winner = true  
29
3011、db.users.find({"username" : {"$in" : [null], "$exists" : true}}) 
31  -- select * from users where username is null 
32  -- 如果直接通过find({"username" : null})进行查询，那么连带"没有username"的纪录一并筛选出来 
3312、db.users.find({"username" : {"$nin" : [null]}}) 
34  -- db.users.find({"username" : {"$ne" : null}}) 
35  -- select * from users where username is not null