/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 vote182 views1 answer
Laravel get data from model to controller
PHP Laravel
11 votes171 views4 answers
Redirect back with input laravel in request
PHP Laravel
56 votes227 views6 answers
Laravel seeder
PHP Laravel
2 votes193 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
1 vote180 views1 answer
Laravel validation types for float
PHP Laravel
0 vote166 views1 answer
Encryption key has not encrypted laravel
PHP Laravel
0 vote178 views1 answer
Laravel dompdf barcode
PHP Laravel
1 vote189 views2 answers
Scheduling in laravel in custom cron
PHP Laravel
5 votes187 views3 answers
Laravel validation time hours minutes format
PHP Laravel
0 vote176 views1 answer
Laravel blade short if
PHP Laravel