/PHP/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 vote353 views2 answers
Wordpress move debug.log
PHP
1 vote469 views2 answers
Faker image laravel 8
PHP Laravel
-1 vote388 views1 answer
Add method to laravel blade
PHP Laravel
2 votes441 views1 answer
Laravel how to test email testing
PHP Laravel
0 vote429 views1 answer
Symfony Expected argument of type "string", "null" given
PHP Symfony
1 vote364 views1 answer
Password validation rules laravel
PHP Laravel
0 vote334 views1 answer
Woocommerce get post terms product
PHP
3 votes449 views1 answer
Codeigniter check insert
PHP CodeIgniter
24 votes384 views4 answers
Clear cache command in laravel controller
PHP
9 votes333 views3 answers
Laravel load view in variable
PHP