mogorepository 嵌套查询
时间: 2023-08-30 09:10:38 浏览: 80
在MongoDB中,可以使用嵌套查询来查询嵌套在文档中的数据。假设我们有一个集合,其中包含以下文档:
```
{
"_id": 1,
"name": "John",
"address": {
"street": "123 Main St",
"city": "Anytown",
"state": "CA",
"zip": "12345"
}
},
{
"_id": 2,
"name": "Jane",
"address": {
"street": "456 Oak St",
"city": "Othertown",
"state": "NY",
"zip": "67890"
}
}
```
如果我们想要查询所有居住在加利福尼亚州的人,我们可以使用以下查询:
```
db.collection.find({"address.state": "CA"})
```
这将返回以下结果:
```
{
"_id": 1,
"name": "John",
"address": {
"street": "123 Main St",
"city": "Anytown",
"state": "CA",
"zip": "12345"
}
}
```
同样,如果我们想要查询所有居住在加利福尼亚州,并且他们的街道是Main St的人,我们可以使用以下查询:
```
db.collection.find({"address.state": "CA", "address.street": "123 Main St"})
```
这将返回以下结果:
```
{
"_id": 1,
"name": "John",
"address": {
"street": "123 Main St",
"city": "Anytown",
"state": "CA",
"zip": "12345"
}
}
```
阅读全文