/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 vote170 views1 answer
Human readable date laravel
PHP Laravel
0 vote185 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel
7 votes153 views3 answers
Ubuntu apache php version
PHP
0 vote156 views1 answer
Set font sytle phpspreadsheet
PHP
0 vote127 views1 answer
Register_uninstall_hook
PHP
1 vote145 views2 answers
How to display data from mysql database into html table using php
PHP
12 votes282 views3 answers
Wordpress embed shortcode in php
PHP Wordpress
0 vote154 views1 answer
Php format phone number with dashes function
PHP
46 votes155 views6 answers
Add column to migration laravel
PHP
1 vote222 views2 answers
Install laravel in ubuntu 20.04
PHP