/PHP/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

2 votes153 views1 answer
How to return chunk data laravel
PHP Laravel
0 vote179 views1 answer
Env clear cache laravel
PHP Laravel
0 vote160 views2 answers
Laravel gmail send mail 2020
PHP
1 vote171 views2 answers
Laravel get query output
PHP Laravel
2 votes169 views1 answer
Php remove null bytes from string
PHP
1 vote148 views1 answer
Laravel difference between fill and update
PHP
0 vote180 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel
2 votes150 views2 answers
404 page in laravel
PHP
0 vote176 views1 answer
Laravel Facades\DB update
PHP Laravel
1 vote148 views1 answer
How validate the becrypt password in laravel
PHP