$all操作符帮助选择collection中field是array类型的,且该array包含所有指定的元素的document。 若使用$all操作符,语法如下:
dbDao 百度贴吧:http://tieba.baidu.com/dbdao
MongoDB技术学习QQ群: 421431253
{ <field>: { $all: [ <value1> , <value2> ... ] } }
使用例子如下
> db.dbdao_col.insert({_id:1,"a":1,"b":[3]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:11,"a":"5","b":[5,3,7]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:111,"a": 1 ,"b":[3,5]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:12,"a": "5" ,"b":["alpha",5]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.find(); { "_id" : 1, "a" : 1, "b" : [ 3 ] } { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } { "_id" : 12, "a" : "5", "b" : [ "alpha", 5 ] } > db.dbdao_col.find({"b": { "$all" : [5,3]}}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } > > > db.dbdao_col.find({"b": { "$all" : [3,5]}}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } > db.dbdao_col.insert({_id:1,"a":1,"b":[3]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:11,"a":"5","b":[5,3,7]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:111,"a": 1 ,"b":[3,5]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.insert({_id:12,"a": "5" ,"b":["alpha",5]}); WriteResult({ "nInserted" : 1 }) > db.dbdao_col.find(); { "_id" : 1, "a" : 1, "b" : [ 3 ] } { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } { "_id" : 12, "a" : "5", "b" : [ "alpha", 5 ] } > db.dbdao_col.find({"b": { "$all" : [5,3]}}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } > > > db.dbdao_col.find({"b": { "$all" : [3,5]}}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] }
$all 其实等价于$and操作符的这种用法,但是写起来太繁琐:
> db.dbdao_col.find({ $and:[ {"b":3},{"b":5}]}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] } > db.dbdao_col.find({ $and:[ {"b":5},{"b":3}]}); { "_id" : 11, "a" : "5", "b" : [ 5, 3, 7 ] } { "_id" : 111, "a" : 1, "b" : [ 3, 5 ] }