mongodb命令---花樣查詢語句

標籤：col   style   lte   ice   查詢語句   back   大於   --   san   

 

閑言少敘

查出價格低於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}
)

mongodb命令---花樣查詢語句