/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

1 vote187 views1 answer
Publish config laravel
PHP
6 votes235 views1 answer
Laravel get project root
PHP
27 votes249 views6 answers
Php for loop array
PHP
4 votes181 views2 answers
Php check timeout
PHP
4 votes226 views2 answers
Check request header laravel
PHP Laravel
0 vote179 views1 answer
Phpoffice create excel and download
PHP
0 vote222 views2 answers
Laravel migration change column order
PHP Laravel
1 vote206 views1 answer
Php remove span tags from string
PHP
0 vote231 views1 answer
Wordpress function _() not working
PHP Wordpress
2 votes193 views1 answer
Live update mysql data in php
PHP