Field Filters
Like
Definition
Filter::field('description', [FilterType::LIKE])
Array/Object Structure
target
string
requiredvalue
string|int|float
requiredExample
$filter = [
'type' => '$like',
'target' => 'description',
'value' => 'Laravel',
];
$sql = Project::filter([$filter])->toRawSql();
SQL
select * from "projects" where "projects"."description" LIKE '%Laravel%'
Modifiers
Start
select * from "projects" where "projects"."description" LIKE 'Laravel%'
End
select * from "projects" where "projects"."description" LIKE '%Laravel'