/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

0 vote166 views2 answers
If product open display this button
PHP
0 vote197 views2 answers
Laravel create event listener
PHP Laravel
0 vote166 views2 answers
Php check if value exists in multidimensional array
PHP
16 votes173 views1 answer
Laravel skip requirements
PHP
2 votes171 views1 answer
Google panel with info name
PHP
8 votes164 views3 answers
Php window location
PHP
28 votes193 views5 answers
Migrate specific table laravel
PHP Laravel
7 votes183 views1 answer
Rollback laravel transaction
PHP Laravel
0 vote179 views1 answer
Laravel lang with parameter
PHP
1 vote179 views1 answer
Php get index of current item array_reduce
PHP