MongoDB集合数据查询

（1）查询所有记录

db.userInfo.find();
相当于：select * from userInfo

(2)查询去重后数据

db.userInfo.distince("name");
相当于：select distinct name from userInfo;

(3)查询age=22的记录

db.userInfo.find({"age",22});
相当于：select *  from userInfo where age=22

(4)查询age>22的记录

db.userInfo.find((age:{$gt:22}});
相当于：select * from userInfo where age>22

(5)查询age<22的记录

db.userInfo.find({age:{$lt:22}});
相当于：select * from userInfo where age<22

(6)查询age>=25的记录

db.userInfo.find({age:{$gte:25}});
相当于：select * from userInfo where age>=25

(7)查询age<=25的记录

db.userInfo.find({age:{$lte:25}});
相当于：select * from userInfo where age<=25

(8)查询age>23并且age<=26

db.userInfo.find({age:{gte:23,$lte:26}});

(9)查询name中包含mongo的数据

db.userInfo.find({name:/mongo/});
相当于：select * from userInfo where name like '%mongo%';

(10)
查询name中以mongo开头的

db.userInfo.find((name:'^mongo/});
相当于：select * from userInfo where name like 'mongo%';

（11）查询指定列name,age数据

db.userInfo.find({},{name:1,age:1});

(12查询指定列name,age数据，age>25

db.userInfo.find({age:{$gt:25}},{name:1,age:1});

(13)按照年龄排序

升序：db.userInfo.find().sort({age:1});
降序：db.userInfo.find().sort({age:-1});

(14)查询name=zhangsan,age=22的数据

db.userInfo.find({name:'zhangsan',age:22});

(15)查询前5条数据

db.userInfo.find().limit(5);

(16)查询10条以后的数据

db.userInfo.find().skip(10)

(17)查询5–10之间的数据

db.userInfo.find().limit(10).skip(5);

(18)or与查询

db.userInfo.find({$or:[{age:22},{age:25|]})

(19)查询第一条 数据

db.userInfo.findOne()

(20)查询某个结果集的记录条数

db.userInfo.find({age:{$gte:25}}).count();