带regex的Mongodb查询

Question

我正在学习Python与mongodb在龙卷风。你知道吗

{
    "_id" : ObjectId("566fb466d82f0769fbb0fb10"),
    "Pid" : "1",
    "Registration" : "1234",
    "Date" : "11-11-2015",
    "status" : "booked"
}
{
    "_id" : ObjectId("566fb47cd82f0769fbb0fb11"),
    "Pid" : "1",
    "Registration" : "1234",
    "Date" : "13-11-2015",
    "status" : "AOs"
}
{
    "_id" : ObjectId("566fb48bd82f0769fbb0fb12"),
    "Pid" : "1",
    "Registration" : "1234",
    "Date" : "14-11-2015",
    "status" : "NA"
}
{
    "_id" : ObjectId("566fb4a3d82f0769fbb0fb13"),
    "Pid" : "1",
    "Registration" : "1234",
    "Date" : "16-12-2015",
    "status" : "AOr"
}

如果我只通过月份和年份，我需要给定月份和年份的完整记录。你知道吗

我试过这样做：

db.cal.aggregate({$project:{"monthyear": {$substr: ["$Date",0,2]}}})

输出为：

{ "_id" : ObjectId("566fb466d82f0769fbb0fb10"), "monthyear" : "11" }
{ "_id" : ObjectId("566fb47cd82f0769fbb0fb11"), "monthyear" : "13" }
{ "_id" : ObjectId("566fb48bd82f0769fbb0fb12"), "monthyear" : "14" }
{ "_id" : ObjectId("566fb4a3d82f0769fbb0fb13"), "monthyear" : "16" }

但我需要以下输出：

 {
  "_id" : ObjectId("566fb4a3d82f0769fbb0fb13")
  "Pid" : "1",
  "Registration" : "1234",
  "Date" : "16-12-2015",
  "status" : "AOr"

  }

求求你，救命

Answer 1

这个呢：

db.cal.find({"Date":{"$regex":"12-2015"}})