Question : add like and equal in same query in laravel
Answered by : romesh-fernando
$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 : https://stackoverflow.com/questions/30761950/laravel-5-like-equivalent-eloquent | Last Update : Mon, 26 Oct 20