/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 vote191 views1 answer
Supervisor configuration for laravel queue
PHP Laravel
10 votes148 views4 answers
Print last query laravel
PHP Laravel
0 vote139 views2 answers
Carbon Format date with timezone in views Laravel
PHP Laravel
0 vote140 views1 answer
How to import in laravel excel command
PHP Laravel
0 vote150 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote121 views1 answer
Import separate graphql file laravel
PHP Laravel
2 votes127 views1 answer
Laravel string key
PHP Laravel
5 votes130 views3 answers
Laravel display error message
PHP Laravel
27 votes127 views3 answers
How to migrate a specific table in laravel
PHP Laravel
0 vote138 views1 answer
How to index column in laravel
PHP Laravel