/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

26 votes232 views6 answers
Drop foreign key laravel
PHP Laravel
13 votes214 views5 answers
Laravel validation custom message example
PHP Laravel
31 votes203 views5 answers
How to make db seeder in laravel
PHP Laravel
0 vote223 views1 answer
Laravel old value not working in textarea
PHP Laravel
0 vote192 views1 answer
How get query logs in laravel
PHP Laravel
2 votes212 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP Laravel
9 votes204 views2 answers
Laravel Str::random
PHP Laravel
0 vote217 views1 answer
Use backpack and laravel-permission to edit user roles
PHP Laravel
0 vote203 views1 answer
Check for headers laravel
PHP Laravel
0 vote203 views2 answers
Laravel collection remove duplicates
PHP Laravel