Arama için scope kullanımını severim:
ClientController.php
$clients = Client::where('DURUM', '1');
if (request()->has('search-clients')) {
$clients->search();
}
$clients = $clients->orderBy('ADI')->paginate(20);
Client.php
public function scopeSearch($query, $string = null)
{
$string = $string ?? mb_strtoupper(request()->get('search-clients'));
return $query->where('ADI', 'LIKE', "%$string%");
}