/PHP/Laravel/Add like and equal in same query in laravel

Add like and equal in same query in laravel

$data = DB::table('borrowers')
        ->join('loans', 'borrowers.id', '=', 'loans.borrower_id')
        ->select('borrowers.*', 'loans.*')   
        ->where('loan_officers', 'like', '%' . $officerId . '%')
        ->where('loans.maturity_date', '<', date("Y-m-d"))
        ->get();

Source: stackoverflow.com

Similar codes

0 vote253 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
0 vote229 views1 answer
Laravel validation get failed rules
PHP Laravel
1 vote233 views1 answer
Laravel unique title except id on edit
PHP Laravel
0 vote253 views1 answer
Doiffernce between text and string in laravel migration
PHP Laravel
0 vote267 views1 answer
Laravel update all relations
PHP Laravel
1 vote255 views1 answer
Image dimension when uploading in laravel validation
PHP Laravel
0 vote274 views2 answers
Laravel collection sort by date
PHP Laravel
2 votes191 views1 answer
Laravel get file name
PHP Laravel
2 votes254 views3 answers
Laravel url with parameters blade
PHP Laravel
8 votes273 views3 answers
Check for an existing user laravel eloquent
PHP Laravel