/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

8 votes230 views5 answers
Wherebetween laravel
PHP Laravel
6 votes153 views6 answers
Install php 7.4
PHP
-1 vote149 views1 answer
Php catch mysqli_connect(): (HY000/1045): Access denied
PHP
9 votes163 views3 answers
Wp_enqueue_script
PHP
1 vote156 views1 answer
Session_destroy not working
PHP
9 votes145 views3 answers
Object values to array php
PHP
0 vote171 views1 answer
Remove rank math next prev canonical
PHP
0 vote193 views1 answer
First-class Callable Syntax - PHP 8.1
PHP
77 votes193 views6 answers
Array length php
PHP
0 vote109 views1 answer
How to remove Website field from comments
PHP