​
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'
Less Than Equal ToNot Between