/PHP/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 vote323 views1 answer
How to disable opcache
PHP
0 vote276 views1 answer
Php pdo set charset
PHP
1 vote251 views2 answers
Htaccess redirect https laravel
PHP
0 vote325 views1 answer
Update Query in Codeigniter Using Multiple Where Condition
PHP CodeIgniter
5 votes239 views2 answers
Php curl get body response
PHP
4 votes254 views3 answers
Laravel return json header json
PHP
0 vote250 views1 answer
Laravel session has message
PHP
1 vote275 views2 answers
Laravel model is dirty
PHP
1 vote251 views1 answer
Laravel controller return message
PHP
0 vote270 views2 answers
Display money format php
PHP