译自:http://docs.mongoing.com/manual-zh/reference/operator/query/nor.html
db.inventory.find({})定义如下:
{
"_id" : 1.0,
"item" : {
"name" : "ab",
"code" : "123"
},
"qty" : 15.0,
"tags" : [
"A",
"B",
"C"
]
}
{
"_id" : 2.0,
"item" : {
"name" : "cd",
"code" : "123"
},
"qty" : 20.0,
"tags" : [
"B"
]
}
{
"_id" : 3.0,
"item" : {
"name" : "ij",
"code" : "456"
},
"qty" : 25.0,
"tags" : [
"A",
"B"
]
}
{
"_id" : 4.0,
"item" : {
"name" : "xy",
"code" : "456"
},
"qty" : 30.0,
"tags" : [
"B",
"A"
]
}
{
"_id" : 5.0,
"item" : {
"name" : "mn",
"code" : "000"
},
"qty" : 20.0,
"tags" : [
[
"A",
"B"
],
"C"
]
}
db.inventory.find( { $nor: [ { qty: 15 }, { qty: 20 }, { qty: 30 }] } )
的查询结果如下:
{
"_id" : 3.0,
"item" : {
"name" : "ij",
"code" : "456"
},
"qty" : 25.0,
"tags" : [
"A",
"B"
]
}