闲言少叙
查出价格低于200的商品信息—-包含商品名称，货物编号，价格，添加信息等
db.goods.find( {"shop_price":{$lt:200}}, {"shop_price":1,"goods_name":1,"goods_id":1,"add_time":1} )
商品分类不为3的商品
db.goods.find( {"cat_id":{$ne:3}}, {"shop_price":1,"goods_name":1,"goods_id":1,"cat_id":1} )
价格低于或等于400的商品
db.goods.find( {"shop_price":{$lte:400}}, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} ）
查处价格大于等于100，小于等于500的商品
db.goods.find( {$and: [{"shop_price":{$lte:500}},{"shop_price":{$gte:100}}] }, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} )
查询不属于栏目3和栏目11的产品用$and
db.goods.find( {$and: [{cat_id:{$ne:3}},{cat_id:{$ne:11}}] }, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} )
查询不属于栏目3和栏目11的产品用$nin
db.goods.find( {"cat_id":{$nin:[3,11]}}, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} )
查询不属于栏目3和栏目11的产品用$nor
db.goods.find( {$nor:[{cat_id:3},{cat_id:11}]}, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1}
)
取出大于100小于300的商品或者小于5000，大于4000的商品
db.goods.find( {$or:[ {$and:[{"shop_price":{$lte:300}},{"shop_price":{$gte:100}},]}, {$and:[{"shop_price":{$lt:5000}},{"shop_price":{$gt:4000}},]} ]}, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} )
取出商品编号对5求余等于1的记录
db.goods.find( {cat_id:{$mod:[5,1]}}, {"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1} )
取出分类为3或11的商品
db.goods.find(
{"cat_id":{$in:[3,11]}},
{"goods_name":1,"goods_id":1,"shop_price":1,"cat_id":1}
)