在 MongoDB 中搜索雜湊陣列?
讓我們首先建立一個包含文件的集合 -
> db.searchAnArrayDemo.insertOne({_id:1,"TechnicalDetails":[{"Language":"MongoDB"}]}); { "acknowledged" : true, "insertedId" : 1 } > db.searchAnArrayDemo.insertOne({_id:2,"TechnicalDetails":[{"Language":"MySQL"}]}); { "acknowledged" : true, "insertedId" : 2 } > db.searchAnArrayDemo.insertOne({_id:3,"TechnicalDetails":[{"Language":"MongoDB"}]}); { "acknowledged" : true, "insertedId" : 3 } > db.searchAnArrayDemo.insertOne({_id:4,"TechnicalDetails":[{"Language":"MongoDB"}]}); { "acknowledged" : true, "insertedId" : 4 } > db.searchAnArrayDemo.insertOne({_id:5,"TechnicalDetails":[{"Language":"Java"}]}); { "acknowledged" : true, "insertedId" : 5 }
以下是透過 find() 方法從集合中顯示所有文件的查詢 -
> db.searchAnArrayDemo.find().pretty();
這將產生以下輸出 -
{ "_id" : 1, "TechnicalDetails" : [ { "Language" : "MongoDB" } ] } { "_id" : 2, "TechnicalDetails" : [ { "Language" : "MySQL" } ] } { "_id" : 3, "TechnicalDetails" : [ { "Language" : "MongoDB" } ] } { "_id" : 4, "TechnicalDetails" : [ { "Language" : "MongoDB" } ] } { "_id" : 5, "TechnicalDetails" : [ { "Language" : "Java" } ] }
以下是搜尋雜湊陣列的查詢 -
> db.searchAnArrayDemo.find({'TechnicalDetails.Language':'MongoDB'}).count();
這將產生以下輸出 -
3
廣告