/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

1 vote152 views1 answer
Insert data using model in laravel 8
PHP Laravel
0 vote148 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP Laravel
0 vote152 views2 answers
What is composer in laravel
PHP Laravel
1 vote147 views1 answer
Autoload file laravel
PHP Laravel
0 vote253 views1 answer
Insert views laravel database
PHP Laravel
0 vote141 views1 answer
Laravel flutter save image in data
PHP Laravel
0 vote190 views1 answer
Laravel request not returning errors
PHP Laravel
1 vote179 views1 answer
Use model from variable laravel
PHP Laravel
0 vote159 views3 answers
Laravel collection each
PHP Laravel
0 vote145 views1 answer
Trying to access variable outside laravel collection
PHP Laravel