mongodb现有的数据是这样
{ "_id" : ObjectId("4ec0b2a4ecb31ca1968000fd"), "id" : 1001, "singer" : "刘德华", "someReview" : [{ "user" : "dong", "text" : "不好听" }, { "user" : "wan", "text" : "打酱油" }, { "user" : "wan", "text" : "真的挺不错,一直很喜欢刘德华" }] }
查出的结果是
{ "user" : "wan", "text" : "打酱油" }
请问改怎么查??谢谢
楼主,你好,假如你的表(collection)叫[color=red]test[/color],可以这样做,
db.test.find({"someReview.user":"wan"},{"someReview.user":1,"someReview.text":1})
第一个参数是查询条件,第二参数是要查询的字段
[code="java"]
db.things.find( { someReview.user: "wan" } );
[/code]