/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

6 votes228 views3 answers
Laravel blade route redirect back
PHP Laravel
-1 vote211 views1 answer
Laravel merge two arrays helper
PHP Laravel
6 votes219 views3 answers
Laravel ide helper
PHP Laravel
10 votes209 views6 answers
Table laravel
PHP Laravel
0 vote253 views1 answer
How to make:trait in commend line in laravel
PHP Laravel
0 vote203 views1 answer
Create fake users on click laravel
PHP Laravel
1 vote194 views1 answer
Integer default value laravel
PHP Laravel
2 votes242 views6 answers
Get last id in laravel
PHP Laravel
0 vote204 views1 answer
Laravel factory relationship one to many
PHP Laravel
0 vote210 views1 answer
Write if and else in one line laravel
PHP Laravel