运用NaviCat进行MongoDB查询管道操作索引等操作

//空值查询

db.myMongoDB.find({"state":null})

//正则查询

db.myMongoDB.find({"content":/^何 /})

//精度查询

db.myMongoDB.find({"phone":{"homePhone":"82174911","mobilePhone":"13065840128"}})

//点查询

db.myMongoDB.find({"phone.homePhone":"62771541"})

//分组 管道操作

// $group

db.myMongoDB.aggregate([{$group:{"_id":"$userid"}}])

//$limit

db.myMongoDB.aggregate({$limit:3})

//$match

db.myMongoDB.aggregate([{$match:{"nickname":"小潘"}}])

//$sort

db.myMongoDB.aggregate([{$sort:{"age":-1}}])

//$project

db.myMongoDB.aggregate([{$project:{"_id":0}}])

//$