AutoSearch.php

trait AutoSearch
{
    public function scopeAutoSearch(Builder $query, ?string $keyword)
    {
        if ($keyword !== null) {
            $dbDriver = DB::connection()->getConfig('driver');

            if ($dbDriver === 'pgsql') {
                $columns = Arr::map($this->searchableColumns, fn ($elm) => $elm.'::text');
                $query->whereLike($columns, $keyword);
            } else {
                $query->whereLike($this->searchableColumns, $keyword);
            }
        }
    }
}