/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 vote103 views2 answers
Laravel check if object empty
PHP
1 vote111 views2 answers
Running laravel as host
PHP Laravel
0 vote88 views1 answer
The requested php extension ext-intl * is missing from your system ubuntu
PHP
0 vote112 views1 answer
Php timezone for manila
PHP
6 votes100 views4 answers
Enset laravel session
PHP Laravel
0 vote128 views1 answer
Uncaught Error: Class 'Illuminate\Foundation\Application' in laravel bootstrap
PHP Laravel
45 votes131 views6 answers
Laravel migration add column after
PHP
1 vote118 views2 answers
Php check credit card expiration
PHP
1 vote94 views3 answers
Hide php extension htaccess
PHP
1 vote99 views3 answers
Wp site url link from admin
PHP