/PHP/Laravel/Laravel where search like with space

Laravel where search like with space

$search_term = $request->input('search_term');
$words = explode(' ', $search_term);
$column = 'column_name';
$data = $data->where(function ($q) use ($column, $words) {
          foreach ($words as $key => $value) {
            $q->where($column, 'like', "%{$value}%");
          }
        })->get();

Similar codes

1 vote298 views1 answer
Where year month laravel
PHP Laravel
0 vote279 views1 answer
Laravel eloquent order by alphabetical order
PHP Laravel
3 votes276 views2 answers
Laravel 7 view @php
PHP Laravel
7 votes297 views1 answer
Laravel wher in
PHP Laravel
0 vote287 views1 answer
Adding another return message from Laravel Livewire
PHP Laravel
0 vote296 views1 answer
Blade check user role laravel
PHP Laravel
1 vote288 views1 answer
Get current month record in laravel
PHP Laravel
26 votes297 views6 answers
Carbon in laravel
PHP Laravel
0 vote291 views1 answer
Mixed content laravel form target
PHP Laravel
4 votes309 views2 answers
Laravel please provide a valid cache path
PHP Laravel