从 MongoDB 中获取 ID 从 234 开始的子文档数组记录
mongodbdatabasebig data analytics更新于 2026/1/6 14:07:17
要从子文档数组中获取记录，请使用 $unwind 和 $push。对于 ID 从 234 开始的记录，请使用 MongoDB 中的正则表达式。
让我们创建一个包含文档的集合 −
> db.demo556.insertOne(
... {
... _id:101,
... details:[
... {
... id:"234336",
... Name:"Chris"
... },
... {
... id:"123456",
... Name:"Bob"
... },
... {
... id:"234987",
... Name:"Carol"
... },
... {
... id:"989768",
... Name:"David"
... },
... {
... id:"234888",
... Name:"Sam"
... },
... {
... id:"847656",
... Name:"John"
... }
... ]
... }
... );
{ "acknowledged" : true, "insertedId" : 101 }
借助 find() 方法显示集合中的所有文档 −
> db.demo556.find();
这将产生以下输出 −
{ "_id" : 101, "details" : [
{ "id" : "234336", "Name" : "Chris" },
{ "id" : "123456", "Name" : "Bob" },
{ "id" : "234987", "Name" : "Carol" },
{ "id" : "989768", "Name" : "David" },
{ "id" : "234888", "Name" : "Sam" },
{ "id" : "847656", "Name" : "John" }
] }
以下是从子文档数组中获取记录的查询 −
> db.demo556.aggregate({
... $match: {
... "_id": 101
... }
... }, {
... $unwind: "$details"
... }, {
... $match: {
... "details.id": {
... $regex: /^234/
... }
... }
... }, {
... $group: {
... _id: "$_id",
... "Detail": {
... $push: "$details"
... }
... }
... }).pretty();
这将产生以下输出 −
{
"_id" : 101,
"Detail" : [
{
"id" : "234336",
"Name" : "Chris"
},
{
"id" : "234987",
"Name" : "Carol"
},
{
"id" : "234888",
"Name" : "Sam"
}
]
}
