陣列物件中的 MongoDB 查詢
我們首先使用文件建立一個集合 -
> db.demo194.insertOne(
... {
... "_id": 101,
... "details": {
... "otherDetails": {
... "List1": ["MongoDB", "MySQL"],
... "List2": ["Java"],
... "List3": ["MongoDB", "C"]
... }
... }
... }
...);
{ "acknowledged" : true, "insertedId" : 101 }
> db.demo194.insertOne( {"_id": 102, "details": { "otherDetails": { "List1": ["Java", "C"], "List2": ["C++"], "List3": ["Python", "Spring"] } } } );
{ "acknowledged" : true, "insertedId" : 102 }使用 find() 方法顯示集合中的所有文件 -
> db.demo194.find();
這將產生以下輸出 -
{ "_id" : 101, "details" : { "otherDetails" : { "List1" : [ "MongoDB", "MySQL" ], "List2" : [ "Java" ], "List3" : [ "MongoDB", "C" ] } } }
{ "_id" : 102, "details" : { "otherDetails" : { "List1" : [ "Java", "C" ], "List2" : [ "C++" ], "List3" : [ "Python", "Spring" ] } } }以下是查詢陣列物件的方法 -
> db.demo194.find({ "details.otherDetails.List1": "MongoDB" })這將產生以下輸出 -
{ "_id" : 101, "details" : { "otherDetails" : { "List1" : [ "MongoDB", "MySQL" ], "List2" : [ "Java" ], "List3" : [ "MongoDB", "C" ] } } }
廣告
資料結構
網路
RDBMS
作業系統
Java
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP