关于mongodb查询问题请教

xingzy1020

请教个mongodb的查询问题。我有这么数据。我要查询 ctime大于5月的数据怎么写。

1. > db.user.find();
   
2. { "_id" : ObjectId("4dc7c9dda9106e44c6657dfd"), "uid" : 1, "username" : "Falcon.C", "age" : 25, "profile" : { "ctime" :
   
3. "2011-01-13 09:25:46.847GMT" } }
   
4. { "_id" : ObjectId("4dc7c9dda9106e44c6657dfe"), "uid" : 2, "username" : "xingzy", "age" : 32, "profile" : { "ctime" : "2
   
5. 011-02-13 09:25:46.847GMT" } }
   
6. { "_id" : ObjectId("4dc7c9dda9106e44c6657dff"), "uid" : 3, "username" : "yujie", "age" : 27, "profile" : { "ctime" : "20
   
7. 11-02-15 09:25:46.847GMT" } }
   
8. { "_id" : ObjectId("4dc7c9dea9106e44c6657e00"), "uid" : 4, "username" : "changjing", "age" : 30, "profile" : { "ctime" :
   
9. "2011-05-09 09:25:46.847GMT" } }
   

复制代码

xingzy1020

解决了。

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

复制代码

TomLeng