Laravel中使用MongoDB

1

db.getCollection('shops').find({'images':{"$elemMatch":{'uurl':{$exists:r=true}}}})

1
2
3
4
5
6
7
8
9

$a = Shop::query()
    ->where('images', '=', [
        '$elemMatch' => [
            'uurl' => [
                '$exists' => ['r' => true]
            ]
        ]
    ])->get();
dd($a);

1

select * from "shops" where "images" = ? and "deleted_at" is null and "meta"."status" != ?

1
2
3
4
5
6

Shop::query()
    ->where('images', '<>', [])
    ->whereNotNull('images')
    ->where('images.uurl', '<>', [])
    ->whereNotNull('images.uurl')
    ->get();