数据: { "_id" : 1, "item" : "abc1", description: "product 1", qty: 300 } { "_id" : 2, "item" : "abc2", description: "product 2", qty: 200 } { "_id" : 3, "item" : "xyz1", description: "product 3", qty: 260 } { "_id" : 4, "item" : "VWZ1", description: "product 4", qty: 330 } { "_id" : 5, "item" : "VWZ2", description: "product 5", qty: 180 }
如何查询出qty不等于180和200的数据?
回复 (3)
D
再配合$or呗
M
@DavidCai1993 db.table.find({ 'qty': {'$ne': {'$or': [180,200]}} }) 对吗?
参与回复
登录后即可参与回复。登录