/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

10 votes158 views2 answers
Get ip address of client php
PHP
14 votes156 views3 answers
How to convert string to int in php laravel
PHP
0 vote163 views1 answer
Carbon start of day
PHP
13 votes150 views3 answers
Laravel make model along with its controller and migration file
PHP
2 votes179 views1 answer
Laravel ever over https
PHP Laravel
1 vote191 views2 answers
Php date function get previous month
PHP
0 vote168 views1 answer
Php check if multiple inputs are empty
PHP
0 vote169 views1 answer
Laravel lang with parameter
PHP
1 vote146 views1 answer
Extract all arrays from sql response in php
PHP
0 vote180 views1 answer
How to check if a url has a certain word in laravel
PHP