/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

3 votes177 views3 answers
Clear laravel.log
PHP Laravel
6 votes168 views1 answer
How to add new column in table laravel
PHP Laravel
28 votes166 views6 answers
Laravel change column type
PHP Laravel
0 vote144 views1 answer
Remove public or index file from url in laravel
PHP Laravel
0 vote131 views1 answer
Laravel print executed query
PHP Laravel
25 votes174 views6 answers
Laravel where
PHP Laravel
0 vote159 views1 answer
Check mobile or email in laravel
PHP Laravel
7 votes169 views3 answers
Laravel migration seed fresh
PHP Laravel
0 vote155 views1 answer
Laravel list get x amount in a collection
PHP Laravel
0 vote105 views1 answer
Add query string to url laravel
PHP Laravel