/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 vote255 views1 answer
Php retrieve data from database and show in text area greeper
PHP
0 vote247 views1 answer
Title active php
PHP
0 vote236 views1 answer
String to lowercase accentuation hyphenated
PHP
15 votes281 views1 answer
Laravel composer install ignore
PHP Laravel
1 vote250 views4 answers
Laravel get route path uri
PHP
0 vote253 views3 answers
Laravel query order by relation
PHP
16 votes250 views4 answers
Wordpress debug mode enabled
PHP
0 vote262 views1 answer
Php has been blocked by CORS policy
PHP
0 vote273 views3 answers
Array fill key use in php project
PHP
0 vote251 views1 answer
Wp post view1
PHP