在MongoDB中按字段名称查找具有特定值的文档？
要通过具有特定值的字段名称查找文档，可以使用$exists运算符。让我们创建包含文档的集合
> db.findByFieldName.insertOne( { "Client":{ "ClientDetails":{ "ClientName":"Larry", "ClientAge":29 }, "ClientProjectDetails":{ "ProjectName":"Online Book Store", "TeamSize":10, "TechnologyUsed":"Spring Boot" } } } );
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9e93b2d628fa4220163b64")
}
> db.findByFieldName.insertOne({
... " Client":{
... " ClientDetails":{
... " ClientName":"Chris",
... " ClientAge":27
... },
... "ClientEducationDetails":{
... " isEducated":true,
... "CollegeName":"M.I.T."
...
... }
... }
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5c9e9421d628fa4220163b65")
}以下是在find()方法的帮助下显示集合中所有文档的查询
> db.findByFieldName.find().pretty();
这将产生以下输出
{
"_id" : ObjectId("5c9e93b2d628fa4220163b64"),
"Client" : {
"ClientDetails" : {
"ClientName" : "Larry",
"ClientAge" : 29
},
"ClientProjectDetails" : {
"ProjectName" : "Online Book Store",
"TeamSize" : 10,
"TechnologyUsed" : "Spring Boot"
}
}
}
{
"_id" : ObjectId("5c9e9421d628fa4220163b65"),
"Client" : {
"ClientDetails" : {
"ClientName" : "Chris",
"ClientAge" : 27
},
"ClientEducationDetails" : {
"isEducated" : true,
"CollegeName" : "M.I.T."
}
}
}以下是按字段名称查找文档的查询
> db.findByFieldName.find({"Client.ClientProjectDetails":{$exists: true}}).pretty();这将产生以下输出
{
"_id" : ObjectId("5c9e93b2d628fa4220163b64"),
"Client" : {
"ClientDetails" : {
"ClientName" : "Larry",
"ClientAge" : 29
},
"ClientProjectDetails" : {
"ProjectName" : "Online Book Store",
"TeamSize" : 10,
"TechnologyUsed" : "Spring Boot"
}
}
}热门推荐
9 敏字的祝福语简短
10 朋友祝福语两字简短
11 毕业祝福语简短英语小学
12 送礼祝福语男性生日简短
13 简短有力的结婚祝福语
14 分手快乐祝福语简短
15 庆祝国家的祝福语简短
16 对司机的祝福语简短
17 朋友弟弟生日祝福语简短
18 老婆生日祝福语简短孩子