首页 / MONGODB / MongoDB下的高级查询示例

MongoDB下的高级查询示例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MongoDB下的高级查询示例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含15002字，纯文字阅读大概需要22分钟。

内容图文

[root@localhost ~]# mongo MongoDB shell version: 1.8.1 connecting to: test gt; db test gt; show collections

[root@localhost ~]# mongo
MongoDB shell version: 1.8.1
connecting to: test
> db
test
> show collections
data_test
system.indexes
system.users
> db.data_test.find().skip(3).limit(4)//分页查询，从第４条记录起，每页４条。
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf57"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "interests" : { "game" : "game4", "ball" : "ball4",
"other" : "nothing4" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf58"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "interests" : { "game" : "game5", "ball" : "ball5",
"other" : "nothing5" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf59"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "interests" : { "game" : "game6", "ball" : "ball6",
"other" : "nothing6" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5a"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "interests" : { "game" : "game7", "ball" : "ball7",
"other" : "nothing7" } }
> db.data_test.find({},{},4,3)//与上相同,注意此页大小和起始位置的位置
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf57"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "interests" : { "game" : "game4", "ball" : "ball4",
"other" : "nothing4" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf58"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "interests" : { "game" : "game5", "ball" : "ball5",
"other" : "nothing5" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf59"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "interests" : { "game" : "game6", "ball" : "ball6",
"other" : "nothing6" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5a"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "interests" : { "game" : "game7", "ball" : "ball7",
"other" : "nothing7" } }
> db.data_test.find().sort({"userName":-1})//order by:按userName倒序
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5c"), "userId" : "10010179", "userName" : "Bill Tu9", "gender" : "m9", "interests" : { "game" : "game9", "ball" : "ball9",
"other" : "nothing9" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5b"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "interests" : { "game" : "game8", "ball" : "ball8",
"other" : "nothing8" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5a"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "interests" : { "game" : "game7", "ball" : "ball7",
"other" : "nothing7" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf59"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "interests" : { "game" : "game6", "ball" : "ball6",
"other" : "nothing6" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf58"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "interests" : { "game" : "game5", "ball" : "ball5",
"other" : "nothing5" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf57"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "interests" : { "game" : "game4", "ball" : "ball4",
"other" : "nothing4" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf56"), "userId" : "10010173", "userName" : "Bill Tu3", "gender" : "m3", "interests" : { "game" : "game3", "ball" : "ball3",
"other" : "nothing3" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf55"), "userId" : "10010172", "userName" : "Bill Tu2", "gender" : "m2", "interests" : { "game" : "game2", "ball" : "ball2",
"other" : "nothing2" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf5d"), "userId" : "100101710", "userName" : "Bill Tu10", "gender" : "m10", "interests" : { "game" : "game10", "ball" :
"ball10", "other" : "nothing10" } }
{ "_id" : ObjectId("4dd7c914b2d5f68db79cdf54"), "userId" : "10010171", "userName" : "Bill Tu1", "gender" : "m1", "interests" : { "game" : "game1", "ball" : "ball1",
"other" : "nothing1" } }
> db.data_test.find({"userName":{$ne:"Bill Tu10"},"age":{$gt:7}})//查询userName!='Bill Tu10' and age>7
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4128"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "age" : 8, "interests" : { "game" : "game8", "ball" :
"ball8", "other" : "nothing8" } }
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4129"), "userId" : "10010179", "userName" : "Bill Tu9", "gender" : "m9", "age" : 9, "interests" : { "game" : "game9", "ball" :
"ball9", "other" : "nothing9" } }
> db.data_test.find({"age":{$gte:2},"age":{$lte:5}})//查询age>=2 and age<=5
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4121"), "userId" : "10010171", "userName" : "Bill Tu1", "gender" : "m1", "age" : 1, "interests" : { "game" : "game1", "ball" :
"ball1", "other" : "nothing1" } }
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4122"), "userId" : "10010172", "userName" : "Bill Tu2", "gender" : "m2", "age" : 2, "interests" : { "game" : "game2", "ball" :
"ball2", "other" : "nothing2" } }
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4123"), "userId" : "10010173", "userName" : "Bill Tu3", "gender" : "m3", "age" : 3, "interests" : { "game" : "game3", "ball" :
"ball3", "other" : "nothing3" } }
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4124"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "interests" : { "game" : "game4", "ball" :
"ball4", "other" : "nothing4" } }
{ "_id" : ObjectId("4dd7cf07b2d5f535b69b4125"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "age" : 5, "interests" : { "game" : "game5", "ball" :
"ball5", "other" : "nothing5" } }
> db.data_test.find({"rank":{$all:[7,7]}})//查询rank=all(7,7)
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb98"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "age" : 7, "rank" : [ 7, 7, 7 ], "interests" : {
"game" : "game7", "ball" : "ball7", "other" : "nothing7" } }
> db.data_test.find({"rank":{$all:[7,7,7]}})//查询rank=all(7,7,7)
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb98"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "age" : 7, "rank" : [ 7, 7, 7 ], "interests" : {
"game" : "game7", "ball" : "ball7", "other" : "nothing7" } }
> db.data_test.find({"userName":{$exists:false}})
> db.data_test.find({"age":{$mod:[2,0]}})//查询age%2==0
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb93"), "userId" : "10010172", "userName" : "Bill Tu2", "gender" : "m2", "age" : 2, "rank" : [ 2, 2, 2 ], "interests" : {
"game" : "game2", "ball" : "ball2", "other" : "nothing2" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb95"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "rank" : [ 4, 4, 4 ], "interests" : {
"game" : "game4", "ball" : "ball4", "other" : "nothing4" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb97"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "age" : 6, "rank" : [ 6, 6, 6 ], "interests" : {
"game" : "game6", "ball" : "ball6", "other" : "nothing6" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb99"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "age" : 8, "rank" : [ 8, 8, 8 ], "interests" : {
"game" : "game8", "ball" : "ball8", "other" : "nothing8" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9b"), "userId" : "100101710", "userName" : "Bill Tu10", "gender" : "m10", "age" : 10, "rank" : [ 10, 10, 10 ], "interests" :
{ "game" : "game10", "ball" : "ball10", "other" : "nothing10" } }
> db.data_test.find({"rank":{$in:[3,4]}})//查询rank in(3,4)
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb94"), "userId" : "10010173", "userName" : "Bill Tu3", "gender" : "m3", "age" : 3, "rank" : [ 3, 3, 3 ], "interests" : {
"game" : "game3", "ball" : "ball3", "other" : "nothing3" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb95"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "rank" : [ 4, 4, 4 ], "interests" : {
"game" : "game4", "ball" : "ball4", "other" : "nothing4" } }
> db.data_test.find({"age":{$nin:[2,3]}})//查询rank not in(2,3)
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb92"), "userId" : "10010171", "userName" : "Bill Tu1", "gender" : "m1", "age" : 1, "rank" : [ 1, 1, 1 ], "interests" : {
"game" : "game1", "ball" : "ball1", "other" : "nothing1" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb95"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "rank" : [ 4, 4, 4 ], "interests" : {
"game" : "game4", "ball" : "ball4", "other" : "nothing4" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb96"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "age" : 5, "rank" : [ 5, 5, 5 ], "interests" : {
"game" : "game5", "ball" : "ball5", "other" : "nothing5" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb97"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "age" : 6, "rank" : [ 6, 6, 6 ], "interests" : {
"game" : "game6", "ball" : "ball6", "other" : "nothing6" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb98"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "age" : 7, "rank" : [ 7, 7, 7 ], "interests" : {
"game" : "game7", "ball" : "ball7", "other" : "nothing7" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb99"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "age" : 8, "rank" : [ 8, 8, 8 ], "interests" : {
"game" : "game8", "ball" : "ball8", "other" : "nothing8" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9a"), "userId" : "10010179", "userName" : "Bill Tu9", "gender" : "m9", "age" : 9, "rank" : [ 9, 9, 9 ], "interests" : {
"game" : "game9", "ball" : "ball9", "other" : "nothing9" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9b"), "userId" : "100101710", "userName" : "Bill Tu10", "gender" : "m10", "age" : 10, "rank" : [ 10, 10, 10 ], "interests" :
{ "game" : "game10", "ball" : "ball10", "other" : "nothing10" } }
> db.data_test.find({$or:[{"age":{$gt:3}},{"rank":{$all:[1,1]}}]})//查询age>3 or rank=all(1,1)
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb92"), "userId" : "10010171", "userName" : "Bill Tu1", "gender" : "m1", "age" : 1, "rank" : [ 1, 1, 1 ], "interests" : {
"game" : "game1", "ball" : "ball1", "other" : "nothing1" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb95"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "rank" : [ 4, 4, 4 ], "interests" : {
"game" : "game4", "ball" : "ball4", "other" : "nothing4" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb96"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "age" : 5, "rank" : [ 5, 5, 5 ], "interests" : {
"game" : "game5", "ball" : "ball5", "other" : "nothing5" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb97"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "age" : 6, "rank" : [ 6, 6, 6 ], "interests" : {
"game" : "game6", "ball" : "ball6", "other" : "nothing6" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb98"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "age" : 7, "rank" : [ 7, 7, 7 ], "interests" : {
"game" : "game7", "ball" : "ball7", "other" : "nothing7" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb99"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "age" : 8, "rank" : [ 8, 8, 8 ], "interests" : {
"game" : "game8", "ball" : "ball8", "other" : "nothing8" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9a"), "userId" : "10010179", "userName" : "Bill Tu9", "gender" : "m9", "age" : 9, "rank" : [ 9, 9, 9 ], "interests" : {
"game" : "game9", "ball" : "ball9", "other" : "nothing9" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9b"), "userId" : "100101710", "userName" : "Bill Tu10", "gender" : "m10", "age" : 10, "rank" : [ 10, 10, 10 ], "interests" :
{ "game" : "game10", "ball" : "ball10", "other" : "nothing10" } }
> db.data_test.find({$nor:[{"age":{$gt:3}},{"rank":{$all:[1,1]}}]})//查询not (age>3 or rank=all(1,1))
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb93"), "userId" : "10010172", "userName" : "Bill Tu2", "gender" : "m2", "age" : 2, "rank" : [ 2, 2, 2 ], "interests" : {
"game" : "game2", "ball" : "ball2", "other" : "nothing2" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb94"), "userId" : "10010173", "userName" : "Bill Tu3", "gender" : "m3", "age" : 3, "rank" : [ 3, 3, 3 ], "interests" : {
"game" : "game3", "ball" : "ball3", "other" : "nothing3" } }
> db.data_test.find({"rank":{$size:3}})//查询rank数组大小为３的记录
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb92"), "userId" : "10010171", "userName" : "Bill Tu1", "gender" : "m1", "age" : 1, "rank" : [ 1, 1, 1 ], "interests" : {
"game" : "game1", "ball" : "ball1", "other" : "nothing1" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb93"), "userId" : "10010172", "userName" : "Bill Tu2", "gender" : "m2", "age" : 2, "rank" : [ 2, 2, 2 ], "interests" : {
"game" : "game2", "ball" : "ball2", "other" : "nothing2" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb94"), "userId" : "10010173", "userName" : "Bill Tu3", "gender" : "m3", "age" : 3, "rank" : [ 3, 3, 3 ], "interests" : {
"game" : "game3", "ball" : "ball3", "other" : "nothing3" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb95"), "userId" : "10010174", "userName" : "Bill Tu4", "gender" : "m4", "age" : 4, "rank" : [ 4, 4, 4 ], "interests" : {
"game" : "game4", "ball" : "ball4", "other" : "nothing4" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb96"), "userId" : "10010175", "userName" : "Bill Tu5", "gender" : "m5", "age" : 5, "rank" : [ 5, 5, 5 ], "interests" : {
"game" : "game5", "ball" : "ball5", "other" : "nothing5" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb97"), "userId" : "10010176", "userName" : "Bill Tu6", "gender" : "m6", "age" : 6, "rank" : [ 6, 6, 6 ], "interests" : {
"game" : "game6", "ball" : "ball6", "other" : "nothing6" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb98"), "userId" : "10010177", "userName" : "Bill Tu7", "gender" : "m7", "age" : 7, "rank" : [ 7, 7, 7 ], "interests" : {
"game" : "game7", "ball" : "ball7", "other" : "nothing7" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb99"), "userId" : "10010178", "userName" : "Bill Tu8", "gender" : "m8", "age" : 8, "rank" : [ 8, 8, 8 ], "interests" : {
"game" : "game8", "ball" : "ball8", "other" : "nothing8" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9a"), "userId" : "10010179", "userName" : "Bill Tu9", "gender" : "m9", "age" : 9, "rank" : [ 9, 9, 9 ], "interests" : {
"game" : "game9", "ball" : "ball9", "other" : "nothing9" } }
{ "_id" : ObjectId("4dd7d214b2d55d5e1db1bb9b"), "userId" : "100101710", "userName" : "Bill Tu10", "gender" : "m10", "age" : 10, "rank" : [ 10, 10, 10 ], "interests" :
{ "game" : "game10", "ball" : "ball10", "other" : "nothing10" } }

内容总结

以上是互联网集市为您收集整理的MongoDB下的高级查询示例全部内容，希望文章能够帮你解决MongoDB下的高级查询示例所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/551665.html

来源：【匿名】

【上一篇】MongoDB索引文件破坏后导致查询错误的问题【下一篇】在MongoDB上如何进行数据的导入与导出

更多 ►

【MongoDB下的高级查询示例】教程文章相关的互联网学习教程文章

MongoDB 如何查询和修改内嵌文档【代码】【图】

MongoDB是文档型的数据库系统，doc是MongoDB的数据单位，每个doc相当于关系型数据库的数据行（row），doc和row的区别在于field的原子性：row中的column是不和分割的原子对象，而doc中的field可以是原子对象，也可以是内嵌doc（embedded doc），数组等数据类型。内嵌doc中所有field的Key不允许重复。例如以下doc，contact 字段是内嵌doc。oneDoc= { name:"t1", age:21, contact:{phone:123,email:"xx@microsoft.com"} }--Insert a d...

MongoDB 匹配查询和比较操作符【代码】

一、匹配查询1. 查询所有> db.accounts.find() { "_id" : "account1", "name" : "alice", "balance" : 100 } { "_id" : ObjectId("5d7f25f4aecbd2bc0fa821b3"), "name" : "charlie", "balance" : 500 } { "_id" : ObjectId("5d7f25f4aecbd2bc0fa821b4"), "name" : "david", "balance" : 200 } { "_id" : { "name" : "david", "balance" : 200 }, "name" : "charlie", "balance" : 500 } { "_id" : { "balance" : 200, "name" : "da...

MongoDB 学习笔记（二）高级查询【图】

1.条件运算符2.$all 匹配所有3.$exists 判断字段是否存在4.NUll 值处理5.$mod 取模处理6.$ne 不等于7. $in 包含,与sql用法相同8. $nin 不包含，与sql用法相同9.$size 数组个数10.正则表达式11.$where 查询12.javascript 查询13.Count、skip、 limit14.sort 排序15.游标16.存储过程 javascript 写法原文：http://www.cnblogs.com/8765h/p/3848477.html

在MongoDB数据库中查询数据(上)【代码】【图】

在MongoDB数据库中查询数据(上)在MongoDB数据库中，可以使用Collection对象的find方法从一个集合中查询多个数据文档，find方法使用方法如下所示：collection.find(selector, [options]);selector值为一个对象，用于指定查询时使用的查询条件，options是可选的参数，该参数值是一个对象，用于指定查询数据时所选用的选项。find方法返回一个代表游标的Cursor对象，在该游标中包含了所有查询到的数据文档信息。可以使用Cursor对象的to...

MongoDB简单使用-查询操作3

首先添加几个文档：dvd = ({"Type":"DVD","Title":"Matrix,The","Released":1994,"Cast":["Keanu Reeves","Carrie-Anne Moss","Laurence Fishburne","Hugo Weaving","Gloria Foster","Joe Pantoliano"]})db.media.insertOne(dvd)dvd = ({"Type":"DVD","Title":"Blade Runner","Released":1982})db.media.insertOne(dvd)dvd = ({"Type":"DVD","Title":"Toy Story 3","Released":2010})db.media.insertOne(dvd)1.比较符号（$gt,$gte,...

mongoDB查询数据

查询数据使用db.表名.find()查询数据如果不指定条件时则默认查询所有例如> db.noPK.find(){ "_id" : ObjectId("5a50642b908e6b07a84472a2"), "name" : "javascript", "value" : "vue.js" }{ "_id" : ObjectId("5a50703c908e6b07a84472a6"), "name" : "shell", "type" : "script" } 指定条件查询> db.noPK.find({"name":"shell"}){ "_id" : ObjectId("5a50703c908e6b07a84472a6"), "name" : "shell", "type" : "script" } 如果希望...

mongodb查询重复数据【代码】

db.getCollection(‘archive_person‘).aggregate( {‘$group‘:{‘_id‘: {‘category‘: ‘$category‘},‘uniqueIds‘: {‘$addToSet‘: ‘$_id‘},‘count‘ : {‘$sum‘: 1}}},{‘$match‘: {‘count‘: {‘$gt‘: 1}}} )category 替换为要查询的重复字段原文：https://www.cnblogs.com/lfyu/p/13634013.html

Mongodb query查询

Query.All("name", "a", "b");//通过多个元素来匹配数组Query.And(Query.EQ("name", "a"), Query.EQ("title", "t"));//同时满足多个条件Query.EQ("name", "a");//等于Query.Exists("type", true);//判断键值是否存在Query.GT("value", 2);//大于>Query.GTE("value", 3);//大于等于>=Query.In("name", "a", "b");//包括指定的所有值,可以指定不同类型的条件和值Query.LT("value", 9);//小于<Query.LTE("value", 8);//小于等于<=Quer...

MongoDB 的高级查询【代码】

一、 MongoDB 聚合管道用途：表关联查询、数据统计。db.COLLECTION_NAME.aggregate(AGGREGATE_OPERATION) 二、 MongoDB Aggregation 管道操作符与表达式管道操作符SQL 和 NOSQL 对比Description$projectSELECT修改输入文档的结构。可以用来重命名、增加或删除域，也可以用于创建计算结果以及嵌套文档。$matchWHERE/HAVING条件匹配。只满足条件的文档才能进入下一阶段$limitLIMIT限制结果的数量$skip跳过文档的数量$sortORDER BY...

MongoDB高级查询用法大全【代码】【图】

转载 http://blog.163.com/lgh_2002/blog/static/440175262012052116455/详见官方的手册：http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-ConditionalOperators%3A%3C%2C%3C%3D%2C%3E%2C%3E%3D版本一： 1 ) . 大于，小于，大于或等于，小于或等于 $gt:大于 $lt:小于 $gte:大于或等于 $lte:小于或等于例子：db.collection.find({ "field" : { $gt: value } } ); // greater than : field > valuedb.co...

mongoDB集合文档创建修改删除以及查询命令总结

mongodb在windows下的安装，启动查看上一篇：mongoDB安装详解一、登录查看数据库数据库中的集合文档添加文档，修改文档，删除文档1、查看有哪些数据库可以用： show dbs; 2、查看当前使用的数据库的名称： db.getName();3、使用某个数据库,和mysql中一样可以进行数据库之间的转化 use dbname;4、如果没有数据库则创建数据库，mongodb没有提供像mysql等的创建数据库的语句但有相似功能的命令：如果有这个数据库则使...

关于mongodb按照字段模糊查询方法

模糊查询：tname包含某个关键字测试‘cd /opt/soft/mongodb/bin./mongo --host 192.168.0.1 --port 17017 testdb.test_info.find({"tname": {$regex: ‘测试‘, $options:‘i‘}}) db.test_info.find({"tname": {$regex:/测试.*/i}}) 原文：http://www.cnblogs.com/liubaihui/p/7814089.html

mongodb避免的查询模式

1少用countdb.testcol1.find({xxx:15}).count() 2 避免large-skipdb.testcol1.find({xxx:15}).skip(100000).limit(10) 3 不用not in本文出自 “dba天空” 博客，请务必保留此出处http://9425473.blog.51cto.com/9415473/1661217原文：http://9425473.blog.51cto.com/9415473/1661217

Mongodb 数组查询

插入多条测试数据> for(i=1;i<=1000;i++){... db.blog.insert({"title":i,"content":"mongodb测试文章。","name":"刘"+i}); ... }db.blog.list.find().limit(10).forEach(function(data){print("title:"+data.title);}) 循环forEach 用法 db.blog.findOne(); 取一条数据db.blog.find();取多条数据db.blog.remove(); 删除数据集 db.blog.drop();删除表删除一个数据库： 1....

PHP查询MongoDB慢的问题

问题背景：公司和腾迅合作开发了一款手游，需要开发一个后台管理平台来统计每日游戏数据；数据量相对比较大的集合有两个，一个是user_info，大约有2453条数据，另外一个是room_data，大约有8456条数据。问题内容：功能开发完毕，可是查询mongodb数据库并显示数据特别慢，用时大约10S。这是什么鬼，为何如此之慢？问题解决办法：首先想到的是给集合添加索引，将所操作集合添加完索引后依旧没有解决问题！汗！什么原因？还是先去问问...

MONGODB - 技术教程分类

MongoDB 教程 MongoDB 简介 MongoDB 概念解析 MongoDB 连接 MongoDB 创建数据库 MongoDB 删除数据库 MongoDB 创建集合 MongoDB 删除集合 MongoDB 插入文档 MongoDB 更新文档 MongoDB 删除文档 MongoDB 查询文档 MongoDB 条件操作符 MongoDB $type 操作符 MongoDB Limit与Skip方法 MongoDB 排序 MongoDB 索引 MongoDB 聚合 MongoDB 复制(副本集) MongoDB 分片 MongoDB 备份与恢复 MongoDB 监控 MongoDB PHP 扩展 Node.js MongoDB MongoDB 关系 MongoDB 数据库引用 MongoDB 覆盖索引查询 MongoDB 查询分析 MongoDB 原子操作 MongoDB 高级索引 MongoDB 索引限制 MongoDB ObjectId MongoDB Map Reduce MongoDB 全文检索 MongoDB 管理工具 MongoDB GridFS MongoDB 固定集合 MongoDB 自动增长 mongodb 全部

MONGODB - 最热教程

TP5(thinkPHP5)框架mongodb扩展安装及特...MongoDB数据库设置初始化脚本【MongoDB】在windows平台下mongodb的分...MongoDB查询超时异常SocketTimeoutExce...mongodb关于启动权限的问题 mongodb chunk 大小设置 MongoDB分片集群配置 mongodb web管理工具rockmongo MongoDB中insert方法、update方法、sav...mongodb如何对子文档进行分页

首页 / MONGODB / MongoDB下的高级查询示例

MongoDB下的高级查询示例

内容导读

内容图文

内容总结

内容备注

内容手机端

【MongoDB下的高级查询示例】教程文章相关的互联网学习教程文章

MongoDB 如何查询和修改内嵌文档【代码】【图】

MongoDB 匹配查询和比较操作符【代码】

MongoDB 学习笔记（二）高级查询【图】

在MongoDB数据库中查询数据(上)【代码】【图】

MongoDB简单使用-查询操作3

mongoDB查询数据

mongodb查询重复数据【代码】

Mongodb query查询

MongoDB 的高级查询【代码】

MongoDB高级查询用法大全【代码】【图】

mongoDB集合文档创建修改删除以及查询命令总结

关于mongodb按照字段模糊查询方法

mongodb避免的查询模式

Mongodb 数组查询

PHP查询MongoDB慢的问题

MONGODB - 相关标签

MONGODB - 技术教程分类

MONGODB - 最新教程

MONGODB - 最热教程