GrafiteInc/Scaffold

<?php

namespace App\Models\Concerns;

use Illuminate\Support\Facades\Schema;

trait DatabaseSearchable
{
    public function search($payload)
    {
        $query = $this->orderBy('created_at', 'desc');

        $columns = Schema::getColumnListing($this->getTable());

        foreach ($columns as $attribute) {
            $query->orWhere($attribute, 'LIKE', "%{$payload}%");
        }

        return $query;
    }
}