mongodb条件操作符
来源:互联网 发布:看图纸软件 编辑:程序博客网 时间:2024/05/22 06:06
样本数据
db.media.find().pretty()
{
"_id" : ObjectId("585f822891c851f743fea7b5"),
"Type" : "DVD",
"Title" : "Blade Runner",
"Released" : 1982
}
{
"_id" : ObjectId("585f824d91c851f743fea7b6"),
"Type" : "DVD",
"Title" : "Tony Story3",
"Released" : 2010
}
{
"_id" : ObjectId("585f828391c851f743fea7b7"),
"Type" : "DVD",
"Title" : "Matrix",
"Released" : 1999
}
执行大于和小于比较$gt、$lt、$gte、$lte
db.media.find({Released:{$gt:1999}})
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
db.media.find({Released:{$gte:1999}})
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
db.media.find({Released:{$lt:1999}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
db.media.find({Released:{$lte:1999}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
获取除特定文档外所有的文档($ne)
db.media.find({Released:{$ne:1999}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
指定一个匹配的数组($in)
db.media.find({Released:{$in:[1999,2000,2001]}})
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
查找不在数组中的文档($nin)
db.media.find({Released:{$nin:[1999,2000,2001]}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
匹配文档中所有的属性($all)
db.media.find({Released:{$all:[1999,2000]}})
没有文档返回,因为没有同时满足发行年份为1999,2000的DVD。
在文档中搜索多个表达式
db.media.find({$or:[{Title:’Matrix’},{Released{$ne:1999}}]})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
返回满足其中任何一个条件的文档
返回含有特定字段的文档
db.media.find({Released:{$exists:true}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
否定任何标准操作符执行的检查($not)
db.media.find({Released:{$gt:1999}})
{ “_id” : ObjectId(“585f824d91c851f743fea7b6”), “Type” : “DVD”, “Title” : “Tony Story3”, “Released” : 2010 }
db.media.find({Released:{$not:{$gt:1999}}})
{ “_id” : ObjectId(“585f822891c851f743fea7b5”), “Type” : “DVD”, “Title” : “Blade Runner”, “Released” : 1982 }
{ “_id” : ObjectId(“585f828391c851f743fea7b7”), “Type” : “DVD”, “Title” : “Matrix”, “Released” : 1999 }
- MongoDB条件操作符
- MongoDB 条件操作符
- [MongoDB]条件操作符
- mongodb条件操作符
- MongoDB 条件操作符
- MongoDB 条件操作符
- MongoDB-基础-条件操作符
- MongoDB 条件操作符说明
- mongodb笔记03(MongoDB 条件操作符)
- MongoDB 高级查询条件操作符
- MongoDB条件操作符 – $type
- MongoDB的条件操作符以及排序
- MongoDB常用命令汇总之条件操作符。
- MongoDB $type 操作符和 条件操作符
- MongoDB条件大量删除操作
- 学习MongoDB--(4-1):MongoDB查询(基本查询条件操作符介绍)
- MongoDB学习之旅七:MongoDB高级查询の条件操作符
- Nosql Mongodb之旅(6)—MongoDB高级查询の条件操作符
- 计算机视觉和 CNN 发展十一座里程碑(附论文下载)
- (笔记)Spring MVC学习指南_下载文件
- 【一步一个脚印】Tomcat+MySQL为自己的APP打造服务器(3-2)Android 和 Service 的交互之POST方式
- MVC封装(一)入口文件
- kali 2016.02版的virtualbox的增强型工具安装教程
- mongodb条件操作符
- (转)单精度类型(float)和双精度类型(double)存储
- 相机使用遇到的问题
- 挖地雷
- hadoop进程WEB无法访问的问题
- Windows Service调试
- Houdini Engine for 3DS Max Installation Guide
- 图像特征点匹配(Matching feature points) to be continued..
- 6.2.2