/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 vote174 views1 answer
Laravel collection forget
PHP Laravel
0 vote205 views1 answer
Laravel add package without updating
PHP Laravel
3 votes179 views2 answers
Set image asset path in laravel
PHP Laravel
20 votes171 views4 answers
Laravel where is null
PHP Laravel
46 votes212 views5 answers
Add column migration laravel
PHP Laravel
6 votes177 views2 answers
Laravel check if request has value
PHP Laravel
-1 vote200 views1 answer
When to create a service in laravel
PHP Laravel
5 votes183 views4 answers
Laravel remove foreign key
PHP Laravel
0 vote202 views1 answer
Laravel where doesn't have
PHP Laravel
0 vote174 views4 answers
Laravel old value for select option
PHP Laravel