/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

7 votes119 views1 answer
Laravel if syntax
PHP Laravel
28 votes130 views6 answers
Laravel drop foreign key
PHP Laravel
7 votes135 views5 answers
Laravel foreach loop index
PHP Laravel
4 votes114 views2 answers
Delete all rows in table laravel
PHP Laravel
0 vote142 views1 answer
Laravel uuid not showing in query
PHP Laravel
8 votes67 views2 answers
Laravel password hash online
PHP Laravel
4 votes115 views2 answers
Display all errors at once in laravel
PHP Laravel
3 votes129 views2 answers
Create variable in laravel blade
PHP Laravel
0 vote118 views1 answer
Laravel controller create command in a folder
PHP Laravel
13 votes117 views6 answers
Laravel delete
PHP Laravel