/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

48 votes178 views3 answers
Php cli display errors
PHP
7 votes181 views2 answers
Laravel carbon get month number
PHP
8 votes199 views2 answers
Laravel passport
PHP Laravel
0 vote194 views1 answer
Fetch data from database withour restarting console php
PHP
0 vote176 views1 answer
Php apply function to array elements
PHP
23 votes165 views2 answers
Serve php file
PHP
1 vote209 views5 answers
Laravel modules
PHP
0 vote182 views1 answer
Bsljeet
PHP
2 votes190 views5 answers
Laravel installation in windows
PHP
42 votes251 views6 answers
Php generate random string
PHP