/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

12 votes155 views3 answers
Do_shortcode
PHP
5 votes140 views3 answers
Get result count codeigniter
PHP
0 vote121 views2 answers
Get taxonomies
PHP
0 vote128 views1 answer
Laravel post request search query
PHP
0 vote154 views2 answers
Laravel set middleware default
PHP
0 vote142 views1 answer
Php formData curl
PHP
8 votes142 views2 answers
Php convert spaces to underscores
PHP
18 votes145 views5 answers
If statement in laravel blade
PHP
1 vote134 views1 answer
Add post meta wordpress
PHP
0 vote154 views1 answer
Spatie/laravel-activitylog display only changed data
PHP