/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

10 votes346 views2 answers
Get current date laravel
PHP Laravel
0 vote328 views1 answer
Add auth middleware to route laravel
PHP Laravel
1 vote347 views2 answers
Laravel 8
PHP Laravel
0 vote338 views1 answer
How to pluck fullname database laravel
PHP Laravel
30 votes340 views6 answers
Laravel auth
PHP Laravel
0 vote359 views1 answer
Laravel return view in web.php
PHP Laravel
1 vote374 views1 answer
Laravel foreach else
PHP Laravel
0 vote357 views1 answer
Laravel How to access imagen uploaded in storage
PHP Laravel
28 votes334 views6 answers
Laravel drop foreign key
PHP Laravel
16 votes385 views6 answers
Laravel run migration
PHP Laravel