/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

0 vote244 views1 answer
Create a exporter in laravel command
PHP Laravel
0 vote251 views1 answer
Laravel display the date the participation was created
PHP Laravel
0 vote260 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
3 votes254 views2 answers
Error handling in laravel
PHP Laravel
0 vote252 views1 answer
How to get yearly chart in laravel
PHP Laravel
6 votes254 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
2 votes242 views2 answers
Laravel throw exception with status code
PHP Laravel
2 votes227 views1 answer
How to use model method in controller in laravel
PHP Laravel
0 vote263 views1 answer
Laravel old value not working in textarea
PHP Laravel
2 votes258 views2 answers
Laravel get public path url
PHP Laravel