/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

4 votes192 views6 answers
Jwt for Laravel
PHP Laravel
5 votes154 views2 answers
Laravel 5 use env variable in blade
PHP Laravel
1 vote141 views2 answers
How to delete a file in laravel
PHP Laravel
5 votes179 views1 answer
Limit 1 1 in laravel query
PHP Laravel
7 votes157 views6 answers
Get current route laravel
PHP Laravel
0 vote151 views1 answer
Old function use in checkbox selected in laravel blade
PHP Laravel
0 vote164 views1 answer
Remove repeated columns laravel
PHP Laravel
0 vote141 views2 answers
Option selected in laravel blade
PHP Laravel
2 votes157 views3 answers
How to share a helper globally laravel
PHP Laravel
1 vote161 views1 answer
Laravel migration add datetime column with default
PHP Laravel