/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

1 vote216 views3 answers
Symfony start
PHP
0 vote184 views1 answer
How get query logs in laravel
PHP
0 vote226 views1 answer
Compiling multiple CSS into ONE CSS with Laravel MIX
PHP Laravel
-1 vote138 views1 answer
How to get the y-m-d using laravel carbon
PHP
2 votes176 views1 answer
Read file data using php
PHP
0 vote232 views1 answer
How to get the root domain in laravel
PHP Laravel
1 vote201 views2 answers
Php file_get_contents online file
PHP
7 votes177 views3 answers
Show php info
PHP
16 votes221 views5 answers
Get user auth in laravel
PHP
3 votes216 views3 answers
Vc_map type number
PHP