​
Definition

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

​
Array/Object Structure

​
type
string
required
$like
​
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

​
type
string
required
$like:start
select * from "projects" where "projects"."description" LIKE 'Laravel%'

​
End

​
type
string
required
$like:end
select * from "projects" where "projects"."description" LIKE '%Laravel'