​
Definition

Filter::field('options->languages', [FilterType::JSON_NOT_CONTAINS]);

See JSON Path Wildcards

​
Array/Object Structure

target
string
required
value
string|int|float
required

​
Example

$filter = [
    'type'   => '$jsonNotContains',
    'target' => 'options->languages',
    'value'  => 'en',
];

$sql = User::filter([$filter])->toRawSql();

​
SQL

select * from "users" where not json_contains("users"."options", '\"en\"', '$."languages"')

​
Modifiers

None available.

JSON LengthLess Than