Definition

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

Array/Object Structure

target
string
required
value
string|int|float
required

Example

$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'