/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 vote264 views10 answers
Laravel sanctum
PHP Laravel
1 vote245 views2 answers
Public laravel htaccess
PHP Laravel
0 vote222 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
0 vote224 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel
3 votes235 views1 answer
Laravel e commerce full project
PHP Laravel
0 vote248 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP Laravel
0 vote260 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP Laravel
1 vote240 views1 answer
Laravel optional route parameter in middle of url
PHP Laravel
0 vote217 views2 answers
Laravel roles and permissions
PHP Laravel
1 vote230 views1 answer
Laravel read file from tmp
PHP Laravel