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不返回字段