/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 vote148 views1 answer
Laravel read origanl value before update
PHP Laravel
0 vote147 views1 answer
Get return value from another function laravel
PHP Laravel
3 votes135 views3 answers
Laravel passport create access token
PHP Laravel
6 votes146 views3 answers
Laravel get single column value
PHP Laravel
0 vote141 views1 answer
Laravel Facades\DB update
PHP Laravel
48 votes242 views6 answers
Laravel joins
PHP Laravel
0 vote140 views1 answer
Laravel notification attach file
PHP Laravel
0 vote137 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Laravel
-2 votes132 views3 answers
Laravel where condition with if
PHP Laravel
0 vote203 views1 answer
Laravel eloquent update quantity
PHP Laravel