xingzy1020 发表于 2011-05-09 19:17

关于mongodb查询问题请教

请教个mongodb的查询问题。我有这么数据。我要查询 ctime大于5月的数据怎么写。> db.user.find();
{ "_id" : ObjectId("4dc7c9dda9106e44c6657dfd"), "uid" : 1, "username" : "Falcon.C", "age" : 25, "profile" : { "ctime" :
"2011-01-13 09:25:46.847GMT" } }
{ "_id" : ObjectId("4dc7c9dda9106e44c6657dfe"), "uid" : 2, "username" : "xingzy", "age" : 32, "profile" : { "ctime" : "2
011-02-13 09:25:46.847GMT" } }
{ "_id" : ObjectId("4dc7c9dda9106e44c6657dff"), "uid" : 3, "username" : "yujie", "age" : 27, "profile" : { "ctime" : "20
11-02-15 09:25:46.847GMT" } }
{ "_id" : ObjectId("4dc7c9dea9106e44c6657e00"), "uid" : 4, "username" : "changjing", "age" : 30, "profile" : { "ctime" :
"2011-05-09 09:25:46.847GMT" } }

xingzy1020 发表于 2011-05-09 20:03

解决了。>db.user.find({'profile.ctime':{$gt:'2011-05-01'}});
{ "_id" : ObjectId("4dc7c9dea9106e44c6657e00"), "uid" : 4, "username" : "changjing", "age" : 30, "profile" : { "ctime" :
"2011-05-09 09:25:46.847GMT" } }

TomLeng 发表于 2011-05-11 09:28

:mrgreen:
页: [1]
查看完整版本: 关于mongodb查询问题请教