​
Definition

Filter::field('age', [FilterType::NOT_BETWEEN]);

​
Array/Object Structure

target
string
required
value
array,size:2
required
value.*
string|int|float
required

​
Example

$filter = [
    'type'   => '$notBetween',
    'target' => 'age',
    'value'  => [18, 65,],
];

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

​
SQL

select * from "people" where "people"."age" not between 18 and 65

​
Modifiers

None available.

LikeNot Between Columns