/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 votes296 views1 answer
How to check query execution time in laravel
PHP Laravel
12 votes321 views2 answers
Get current authenticated user laravel
PHP Laravel
1 vote279 views1 answer
Check which database connect laravel
PHP Laravel
0 vote314 views1 answer
Laravel collection average
PHP Laravel
0 vote302 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
3 votes289 views3 answers
Laravel get a url using name
PHP Laravel
0 vote296 views1 answer
Get url parameter laravel 5.2 constructor
PHP Laravel
1 vote340 views1 answer
Static function model laravel
PHP Laravel
31 votes285 views5 answers
How to make db seeder in laravel
PHP Laravel
0 vote320 views1 answer
Laravel with callback
PHP Laravel