php mongodb 常用查询

// 等值查询 where name = "an"
$querys = ["name" => "shian"];

// 数值大于  where number > 5
$querys = ["number" => ['$gt' => 5]];

// 数值大于或等于 where number >= 2
$querys = ["number" => ['$gte' => 2]];

// 数值小于 where number < 5
$querys = ["number" => ['$lt' => 5]];

// 数值小于或等于 where number >= 2
$querys = ["number" => ['$lte' => 2]];

// 数值介于 where number between 1 and 9
$querys = ["number" => ['$gt' => 1, '$lt' => 9]];

// 数值不等于
$querys = ["number" => ['$ne' => 9]];

// js查询
$js = "function(){
return this.number == 2 && this.name == 'shian';
}";
$querys = ['$where' => $js];

$querys = ["childs.id"=>['$in' => [1]]];
$querys = ["childs.name" => ['$regex' => '.*赛季.*']];

// in查询 where number in (1, 2, 9)
$querys = ["number" => ['$in' => [1, 2, 9]]];

// not in查询 where number not in (1, 2, 9)
$querys = ["number" => ['$nin' => [1, 2, 9]]];

// 正则
$querys = ["name" => new MongoRegex("/shi/$i")];

// 或查询 where number =2  or number = 9
$querys = ['$or' => [['number' => 2], ['number' => 9]]];