/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

7 votes141 views1 answer
Php get version
PHP
0 vote146 views2 answers
Check method in laravel
PHP
0 vote173 views1 answer
Show all laravel valet folders
PHP
21 votes147 views1 answer
Php delete array item by value not key
PHP
0 vote140 views1 answer
Hide all updates from WordPress
PHP Wordpress
0 vote161 views1 answer
Order table in laravel
PHP
0 vote148 views1 answer
How to get all the records with same ID in laravel
PHP Laravel
7 votes131 views2 answers
Reset wordpress password in database
PHP
0 vote137 views1 answer
Laravel use npm package
PHP
0 vote131 views1 answer
Get url segment in php
PHP