MongoDB数组查询问题，急！！！！！！！！！！！！

[小衲还需努力]

{
"_id" : ObjectId("53392746d45e260de2d28d5c"),
"Id" : 100,
"info" : [
{
"GT" : NumberLong("61417782000"),
"T" : 1,
"LG" : 1.100000023841858,
"LT" : 1.100000023841858,
"SD" : 99990000,
"ST" : NumberLong(0),
"AN" : 0,
"AL" : NumberLong(0)
}
{
"GT" : NumberLong("61417782000"),
"T" : 1,
"LG" : 1.100000023841858,
"LT" : 1.100000023841858,
"SD" : 99990001,
"ST" : NumberLong(0),
"AN" : 0,
"AL" : NumberLong(0)
}
{
"GT" : NumberLong("61417782000"),
"T" : 1,
"LG" : 1.100000023841858,
"LT" : 1.100000023841858,
"SD" : 99990002,
"ST" : NumberLong(0),
"AN" : 0,
"AL" : NumberLong(0)
}
{
"GT" : NumberLong("61417782000"),
"T" : 1,
"LG" : 1.100000023841858,
"LT" : 1.100000023841858,
"SD" : 99990003,
"ST" : NumberLong(0),
"AN" : 0,
"AL" : NumberLong(0)
}
]
}


这样的结构我要范围查询怎么查啊？？？（例如以SD为键值查找范围在（99990000到99990004之间的所有数组信息））

[healer_kx]

http://www.cnblogs.com/egger/archive/2013/06/14/3135847.html

[jielovehuan]

db.collection.find({"info":{"$elemMatch":{"SD":{"$lt":99990004,"$gt":99990000}}}})