Answers for "like query with laravel"

PHP
0

laravel 8 db like query

$filterData = DB::table('countries')->where('name','LIKE','%'.$term.'%')
                      ->get();
Posted by: Guest on July-15-2021
0

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();
Posted by: Guest on October-19-2020

Browse Popular Code Answers by Language