Not Like

Definition

Filter::field('description', [FilterType::NOT_LIKE])

string

required

$notLike

string

required

string|int|float

required

$filter = [
    'type'   => '$notLike',
    'target' => 'description',
    'value'  => 'Symfony',
];

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

select * from "projects" where "projects"."description" NOT LIKE '%Symfony%'

string

required

$notLike:start

select * from "projects" where "projects"."description" NOT LIKE 'Symfony%'

string

required

$notLike:end

select * from "projects" where "projects"."description" NOT LIKE '%Symfony'