(1)查询所有记录
db.userInfo.find();
相当于:select * from userInfo
1
2
(2)查询去重后数据
db.userInfo.distince("name");
相当于:select distinct name from userInfo;
1
2
(3)查询age=22的记录
db.userInfo.find({"age",22});
相当于:select * from userInfo where age=22
1
2
(4)查询age>22的记录
db.userInfo.find((age:{$gt:22}});
相当于:select * from userInfo where age>22
1
2
(5)查询age<22的记录
db.userInfo.find({age:{$lt:22}});
相当于:select * from userInfo where age<22
1
2
(6)查询age>=25的记录
db.userInfo.find({age:{$gte:25}});
相当于:select * from userInfo where age>=25
1
2
(7)查询age<=25的记录
db.userInfo.find({age:{$lte:25}});
相当于:select * from userInfo where age<=25
1
2
(8)查询age>23并且age<=26</