/PHP/Laravel/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 votes148 views2 answers
Laravel migrate fresh and seed
PHP Laravel
0 vote117 views1 answer
Return pdft download and back with msg in laravel
PHP Laravel
39 votes130 views6 answers
Foreign key laravel migration
PHP Laravel
3 votes114 views2 answers
Order number generate laravel
PHP Laravel
0 vote120 views1 answer
Json whereIn laravel
PHP Laravel
9 votes137 views3 answers
Laravel enum migration example
PHP Laravel
-1 vote119 views1 answer
Laravel merge two arrays helper
PHP Laravel
7 votes126 views5 answers
Laravel if else condition in blade file
PHP Laravel
2 votes126 views3 answers
How to change the colum type in migration laravel
PHP Laravel
0 vote122 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP Laravel