MongoDB按子字段查询？
您可以使用点（。）表示法按子字段进行查询。让我们用文档创建一个集合。使用文档创建集合的查询如下-
> db.queryBySubFieldDemo.insertOne(
... {
... "StudentPersonalDetails" : {"StudentName" : "John","StudentHobby" :"Photography"},
... "StudentScores" : {"MathScore" : 56}
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5c92c2995259fcd195499808")
}
> db.queryBySubFieldDemo.insertOne(
... {
... "StudentPersonalDetails" : {"StudentName" : "Chris","StudentHobby" :"Reading"},
... "StudentScores" : {"MathScore" : 97}
... }
... );
{
"acknowledged" : true,
"insertedId" : ObjectId("5c92c2df5259fcd195499809")
}在find()method的帮助下显示集合中的所有文档。查询如下-
> db.queryBySubFieldDemo.find().pretty();
以下是输出-
{
"_id" : ObjectId("5c92c2995259fcd195499808"),
"StudentPersonalDetails" : {
"StudentName" : "John",
"StudentHobby" : "Photography"
},
"StudentScores" : {
"MathScore" : 56
}
}
{
"_id" : ObjectId("5c92c2df5259fcd195499809"),
"StudentPersonalDetails" : {
"StudentName" : "Chris",
"StudentHobby" : "Reading"
},
"StudentScores" : {
"MathScore" : 97
}
}这是按子字段查询-
> db.queryBySubFieldDemo.find({"StudentPersonalDetails.StudentName":"Chris"}).pretty();以下是输出-
{
"_id" : ObjectId("5c92c2df5259fcd195499809"),
"StudentPersonalDetails" : {
"StudentName" : "Chris",
"StudentHobby" : "Reading"
},
"StudentScores" : {
"MathScore" : 97
}
}热门推荐
10 回家长的祝福语简短
11 祝美术老师祝福语简短
12 孙女结婚姥姥祝福语简短
13 职场离职文案祝福语简短
14 写给情侣祝福语 浪漫简短
15 六一祝福语简短感动女生
16 姐姐女儿结婚祝福语简短
17 家庭英语祝福语短句简短
18 对生活祝福语简短精辟