/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

8 votes342 views6 answers
Laravel eloquent with
PHP Laravel
0 vote434 views3 answers
Email or phone required in laravel
PHP Laravel
0 vote315 views3 answers
Laravel package console command
PHP Laravel
2 votes343 views3 answers
Laravel blade time difference
PHP Laravel
1 vote362 views2 answers
Update checkbox value in laravel
PHP Laravel
0 vote414 views1 answer
Laravel count without pagination
PHP Laravel
1 vote379 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
0 vote394 views1 answer
Data type for price in laravel
PHP Laravel
16 votes365 views5 answers
Laravel blade for loop
PHP Laravel
20 votes353 views2 answers
Schema error laravel
PHP Laravel