/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 vote297 views1 answer
Laravel return list of ids
PHP Laravel
1 vote222 views1 answer
$posts- links() laravel design error
PHP Laravel
0 vote227 views1 answer
Laravel response download video laravel medialibrary
PHP Laravel
0 vote225 views2 answers
Value() in laravel
PHP Laravel
0 vote247 views2 answers
How to get just the first row from a table in laravel
PHP Laravel
0 vote392 views1 answer
Laravel 8 Factory - One To Many (Polymorphic) Relationship
PHP Laravel
3 votes258 views2 answers
Laravel model exists id
PHP Laravel
1 vote219 views2 answers
Get database name laravel
PHP Laravel
49 votes305 views6 answers
Laravel when
PHP Laravel
4 votes297 views3 answers
Laravel migration index
PHP Laravel