/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

1 vote324 views1 answer
Php laravel string substring
PHP Laravel
5 votes339 views4 answers
Laravel remove foreign key
PHP Laravel
0 vote360 views3 answers
Writing into the database with one click laravel
PHP Laravel
12 votes324 views2 answers
Timestamp false in laravel
PHP Laravel
1 vote341 views1 answer
Increment single column laravel
PHP Laravel
0 vote335 views1 answer
Laravel keep old input
PHP Laravel
0 vote352 views1 answer
Combine 2 columns search query laravel
PHP Laravel
0 vote367 views1 answer
Laravel cron job on shared hosting
PHP Laravel
1 vote333 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
0 vote349 views1 answer
Select max id laravel
PHP Laravel