How to Filter To Lowercase?

[bogordesaincom]

I'm use Postgresql when i create custom filter like this :

<?php
....
    public function __invoke(Builder $query, $value, string $property): Builder
    {
        return $query->where('id', 'LIKE', '%'.$value.'%')
            ->orWhere(function (Builder $query) use ($value) {
                return $query->where('name', 'LIKE', '%'.$value.'%');
            });
    }

When Searching Name results is fine, but if i searching name this can't get results

[abkrim]

Use 'ILKE' instead or read this about citext — a case-insensitive character string type Tip