/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 vote289 views1 answer
Laravel pagination publish command
PHP Laravel
2 votes205 views2 answers
How to make doctrine schema update in symfony 2.8
PHP
0 vote209 views1 answer
Saleor meaning
PHP
9 votes193 views3 answers
Php append line to file
PHP
0 vote194 views1 answer
Failed to authenticate on SMTP server with username
PHP
0 vote213 views2 answers
Jquery is less than or equal to
PHP
28 votes205 views6 answers
How to get data from json array in php
PHP
1 vote284 views1 answer
How to add property to the request object in laravel
PHP Laravel
2 votes220 views2 answers
Switch between php version ubuntu nginx
PHP
0 vote215 views1 answer
Migration not found laravel
PHP