/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 vote273 views1 answer
Token delete laravel
PHP Laravel
1 vote311 views1 answer
Clear bootstrap cache laravel
PHP Laravel
0 vote269 views3 answers
GetClientOriginalExtension laravel
PHP Laravel
13 votes283 views6 answers
How to run laravel project
PHP Laravel
4 votes287 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
22 votes283 views6 answers
Laravel where like
PHP Laravel
5 votes281 views3 answers
Laravel get view variables
PHP Laravel
0 vote336 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
0 vote279 views1 answer
Install pusher package in laravel
PHP Laravel
6 votes241 views2 answers
Blade ::if
PHP Laravel