Like

Definition

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

string

required

$like

string

required

string|int|float

required

$filter = [
    'type'   => '$like',
    'target' => 'description',
    'value'  => 'Laravel',
];

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

select * from "projects" where "projects"."description" LIKE '%Laravel%'

string

required

$like:start

select * from "projects" where "projects"."description" LIKE 'Laravel%'

string

required

$like:end

select * from "projects" where "projects"."description" LIKE '%Laravel'