mysql - 如果使用 MYSQL MARIADB，column1 中的 key1 等于 value1 并且 key2 等于 column2 中的 value2，如何在两列中进行搜索？

Question

一栏有效

whereJsonContains('VehicleApplications'
        ,['ModelName' => $model, 'YearID' => $year] )->paginate(10);

Answer 1

如果有人知道发布更清晰的查询，请确保定义变量类型

    $make       = (string) $make;
    $model      = (string) $model;
    $year       = (int) $year;
    $category   = (int) $category;

    whereJsonContains('VehicleApplications',
        ['ModelName' => $model, 'YearID' => $year]
    )->
    whereJsonContains('pcItems',
        ['pcCategoryID' => $category]
    )->paginate(10);