// 等值查询 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]]];
php mongodb 常用查询
本文详细介绍了MongoDB的各种查询操作,包括等值查询、范围查询、正则匹配、不等于查询、逻辑运算符以及组合查询。同时,还涵盖了'in'和'not in'操作符,以及使用JavaScript进行复杂条件筛选。通过这些示例,读者可以深入理解MongoDB的数据查询能力。
摘要由CSDN通过智能技术生成