關于mongodb查詢問題請教

xingzy1020

請教個mongodb的查詢問題。我有這么數(shù)據(jù)。我要查詢 ctime大于5月的數(shù)據(jù)怎么寫。

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