/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

16 votes114 views6 answers
Laravel validation array
PHP Laravel
2 votes132 views1 answer
Laravel model id string
PHP Laravel
0 vote131 views1 answer
Laravel get fillable attributes
PHP Laravel
2 votes122 views4 answers
Foreach in laravel
PHP Laravel
2 votes122 views1 answer
Laravel wherin softdelete
PHP Laravel
7 votes141 views2 answers
Laravel migrate fresh and seed
PHP Laravel
1 vote121 views1 answer
Laravel uppercase first letter
PHP Laravel
0 vote116 views2 answers
How do we calculate average in laravel 8
PHP Laravel
12 votes111 views6 answers
Set session data in laravel
PHP Laravel
1 vote105 views2 answers
Database//Eloquent//Model.php laravel errror array t- string conversion
PHP Laravel