[Database] MongoDB (3) Mongo Query Language 类似Sql语句

Mongo Query Language 类似 Sql 语句

$query - 查询类似于sql中的　where
$orderby - 排序{x:1},1为升序　-1为降序

$query - 查询类似于sql中的　where
$orderby - 排序{x:1},1为升序　-1为降序

// select * from table where name = " abeen " order by age asc
In [ 28 ]: list(table.find({ " $query " : { " name " : " abeen " }, " $orderby " : { " age " : 1 }}))

// select * from table where name = " abeen " order by age desc
In [ 29 ]: list(table.find({ " $query " : { " name " : " abeen " }, " $orderby " : { " age " : - 1 }}))

//select name, address from table where name like '%a%'
按找指定字段按条件，并可指定排序 1:返回字段，0不返回字段

In [ 21 ]: list(t.find({ " name " :{ " $regex " : r " .*a.* " }},{ " name " : 1 , " address " : 1 }))
Out[ 23 ]:
[{u ' _id ' : ObjectId( ' 4c5f9cbc421aa90fb9000000 ' ), u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c5f9ccb421aa90fb9000001 ' ), u ' name ' : u ' shanshan ' },
{u ' _id ' : ObjectId( ' 4c5f9d2d421aa90fb9000002 ' ), u ' name ' : u ' shanshan2 ' },
{u ' _id ' : ObjectId( ' 4c5f9d34421aa90fb9000003 ' ), u ' name ' : u ' shanshan3 ' },
{u ' _id ' : ObjectId( ' 4c5fa2ab421aa90fb9000004 ' ), u ' address ' : u ' da zhong si ' , u ' name ' : u ' shanshan3 ' },
{u ' _id ' : ObjectId( ' 4c5facc6421aa90fb9000005 ' ), u ' name ' : [u ' abeen ' , u ' a ' , u ' b ' , u ' e ' , u ' e ' , u ' n ' ]},
{u ' _id ' : ObjectId( ' 4c5fcd7e421aa90fb9000007 ' ), u ' name ' : u ' abeen_object ' },
{u ' _id ' : ObjectId( ' 4c64b432421aa90697000000 ' ), u ' address ' : u ' shandong ' , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b438421aa90697000001 ' ), u ' address ' : u ' shandong ' , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b43d421aa90697000002 ' ), u ' address ' : u ' shandong ' , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b441421aa90697000003 ' ), u ' address ' : u ' shandong ' , u ' name ' : u ' abeen ' }]

0为不返回字段

In [ 24 ]: list(t.find({ " name " :{ " $regex " : r " .*a.* " }},{ " address " :0}))
Out[ 24 ]:
[{u ' _id ' : ObjectId( ' 4c5f9cbc421aa90fb9000000 ' ), u ' age ' : 27 , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c5f9ccb421aa90fb9000001 ' ), u ' age ' : 22 , u ' name ' : u ' shanshan ' },
{u ' _id ' : ObjectId( ' 4c5f9d2d421aa90fb9000002 ' ), u ' age ' : 22 , u ' name ' : u ' shanshan2 ' },
{u ' _id ' : ObjectId( ' 4c5f9d34421aa90fb9000003 ' ), u ' age ' : 23 , u ' name ' : u ' shanshan3 ' },
{u ' _id ' : ObjectId( ' 4c5fa2ab421aa90fb9000004 ' ), u ' age ' : 23 , u ' name ' : u ' shanshan3 ' },
{u ' _id ' : ObjectId( ' 4c5facc6421aa90fb9000005 ' ), u ' name ' : [u ' abeen ' , u ' a ' , u ' b ' , u ' e ' , u ' e ' , u ' n ' ]},
{u ' _id ' : ObjectId( ' 4c5fcd7e421aa90fb9000007 ' ), u ' name ' : u ' abeen_object ' },
{u ' _id ' : ObjectId( ' 4c64b432421aa90697000000 ' ), u ' age ' : 22 , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b438421aa90697000001 ' ), u ' age ' : 23 , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b43d421aa90697000002 ' ), u ' age ' : 24 , u ' name ' : u ' abeen ' },
{u ' _id ' : ObjectId( ' 4c64b441421aa90697000003 ' ), u ' age ' : 18 , u ' name ' : u ' abeen ' }]

 

转载于:https://www.cnblogs.com/abeen/archive/2010/08/18/1802751.html