資料結構
網路
RDBMS
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化學
生物
數學
英語
經濟
心理學
社會科學
時尚研究
法學研究在 MongoDB 中查詢物件陣列中的結果並匹配電子郵件地址欄位？
我們先使用文件建立一個集合 −
>db.demo144.insertOne({"EmployeeDetails":[{"EmployeeName":"Chris","EmployeeEmail":"Chris12@gmail.com"},{"EmployeeName":"Bob","EmployeeEmail":"bo22@gmail.com"}]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e32f1d8fdf09dd6d08539b9")
}
>db.demo144.insertOne({"EmployeeDetails":[{"EmployeeName":"David","EmployeeEmail":"david@gmail.com"},{"EmployeeName":"Carol","EmployeeEmail":"Carol@gmail.com"}]});
{
"acknowledged" : true,
"insertedId" : ObjectId("5e32f1f5fdf09dd6d08539ba")
}藉助 find() 方法顯示集合中的所有文件 −
> db.demo144.find();
這將生成以下輸出 −
{
"_id" : ObjectId("5e32f1d8fdf09dd6d08539b9"), "EmployeeDetails" : [
{ "EmployeeName" : "Chris", "EmployeeEmail" : "Chris12@gmail.com" },
{ "EmployeeName" : "Bob", "EmployeeEmail" : "bo22@gmail.com" }
]
}
{
"_id" : ObjectId("5e32f1f5fdf09dd6d08539ba"), "EmployeeDetails" : [
{ "EmployeeName" : "David", "EmployeeEmail" : "david@gmail.com" },
{ "EmployeeName" : "Carol", "EmployeeEmail" : "Carol@gmail.com" }
]
}以下是查詢物件陣列中的結果並匹配電子郵件地址欄位的查詢 −
>db.demo144.find({"EmployeeDetails.EmployeeName":"David","EmployeeDetails.EmployeeEmail":"david@gmail.com"},{"EmployeeDetails.EmployeeName":1});這將生成以下輸出 −
{ "_id" : ObjectId("5e32f1f5fdf09dd6d08539ba"), "EmployeeDetails" : [ { "EmployeeName" : "David" }, { "EmployeeName" : "Carol" } ] }
更新時間：31-3-2020
249 瀏覽
廣告