Mongodb查

1.select
    select * from people
    db.people.find()
2.显示想要的字段
    select name,age from people
    db.people.find({},{name:1,age:1,_id:0})
                    第一个{}是进行过滤的地方，第二个{}是确认显示的字段
3.过滤
    select name from people where name='zhangsan'
    db.people.find({name:"zhangsan"},{name:1})
4.不等于
    select name,age from people where age<>18
    db.people.find({age:{$ne:18}})
5.OR条件
    select name,age from people where name='zhangsan' and age=18
    db.people.find({$or:[{name:"zhangsan"},{age:18}]},{name:1,age:1})
6.小于
    select name from people where age<18
    db.people.find({age:{$lt:18}},{name:1})
7.like查询
    select * from people where name like '%sna%'
    db.people.find({name:{$regex:/sna/}})
    db.people.find({name:/sna/})

    select * from people where name like 'sa%'
    db.people.find({name:/^sa/})
8.排序
    select * from people order by age
    db.people.find().sort({age:1})
9.Count 
    select count(*) from people
    db.people.find().count()
    db.people.count()

    select count(name) from people
    db.people.find({name:{$exists:true}}).count()
    db.people.count({name:{$exists:true}})
10.Limit
    select * from people limit 5
    db.people.find().limit(5)
11.skip
    select * from people limit 5 skip 10
    db.people.find().limit(5).skip(10)
12.distinct
    select distinct name from people
    db.people.aggregate([$group:{_id:"$name"}])