MongoDB比较运算符

*【$eq - 等于, $ne - 不等于, $gt - 大于, $gte - 大于等于, $lt - 小于, $lte - 小于等于, $in - 任意包含, $nin - 不包含
】

#1.使用数据库
use sampleDB

#2.插入数据
db.companies.insertMany([
… {number_of_employees:98,name:“nn”,founded_year:2008},
… {number_of_employees:103,name:“mm”,founded_year:2005},
… {number_of_employees:34,name:“ee”,founded_year:2006},
… {number_of_employees:111,name:“dd”,founded_year:2012},
… {number_of_employees:34,name:“kk”,founded_year:2007},
… {number_of_employees:100,name:“pp”,founded_year:2013}
… ]);

#3.查看companies集合的文档字段组成
db.companies.findOne()

#4.查询companies集合中number_of_employees字段小于等于100的文档，且只返回name和number_of_employees字段
db.companies.find({number_of_employees:{$lte:100}},name=1,number_of_employees=1，_id=0)

#5.查询companies集合中founded_year字段等于2005或者2006或者2007的文档，且只返回name和founded_year字段。
db.companies.find({“founded_year”:{$in: [2005,2006,2007]}},{“_id”:0,“number_of_employees”:0})

#6.查询companies集合中founded_year字段既不等于2012也不等2013的文档，且只返回name和founded_year字段。
db.companies.find({“founded_year”:{$nin: [2012,2013]}},{“_id”:0,“number_of_employees”:0})