欢迎访问 生活随笔！
TAG聚合

生活随笔

当前位置： 首页 > 编程资源 > 编程问答 >内容正文

编程问答

mongoDB条件操作符

发布时间：2025/7/25 编程问答 48 豆豆
生活随笔 收集整理的这篇文章主要介绍了 mongoDB条件操作符 小编觉得挺不错的,现在分享给大家,帮大家做个参考.
mongoDB 常用的条件操作符有 $lt 小于 $gt 大于 $lte 小于或等于 $gte 大于或等于 $ne 不等于 $in in 判断用于判断元素是否在数组里面 $nin not in 判断用于判断元素是不是不在数组里面 $or 或判断 > db.tianyc02.find() { "_id" : ObjectId("50ea6eba12729d90ce6e3423"), "name" : "xttt", "age" : 111 } { "_id" : ObjectId("50ea6eba12729d90ce6e3424"), "name" : "xttt", "age" : 222 } { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({age:{$lt:100}}) { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({age:{$lt:100,$gt:20}}) { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({age:{$ne:11}}) { "_id" : ObjectId("50ea6eba12729d90ce6e3423"), "name" : "xttt", "age" : 111 } { "_id" : ObjectId("50ea6eba12729d90ce6e3424"), "name" : "xttt", "age" : 222 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } 2.2 $in & $nin > db.tianyc02.find() { "_id" : ObjectId("50ea6eba12729d90ce6e3423"), "name" : "xttt", "age" : 111 } { "_id" : ObjectId("50ea6eba12729d90ce6e3424"), "name" : "xttt", "age" : 222 } { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({age:{$in:[11,22]}}) { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({age:{$nin:[11,22]}}) { "_id" : ObjectId("50ea6eba12729d90ce6e3423"), "name" : "xttt", "age" : 111 } { "_id" : ObjectId("50ea6eba12729d90ce6e3424"), "name" : "xttt", "age" : 222 } 2.3 $or > db.tianyc02.find({$or:[{age:11},{age:22}]}) { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 } { "_id" : ObjectId("50ea6b7312729d90ce6e341c"), "name" : "xtt", "age" : 22 } > db.tianyc02.find({$or:[{age:11},{name:'xttt'}]}) { "_id" : ObjectId("50ea6eba12729d90ce6e3423"), "name" : "xttt", "age" : 111 } { "_id" : ObjectId("50ea6eba12729d90ce6e3424"), "name" : "xttt", "age" : 222 } { "_id" : ObjectId("50ea6b6f12729d90ce6e341b"), "name" : "xtt", "age" : 11 }

转载于:https://www.cnblogs.com/SunshineLittleCat/p/8280101.html

总结

以上是生活随笔为你收集整理的mongoDB条件操作符的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。