jeudi 17 décembre 2015

laravel querybuilder how to use like in wherein function

$book = array('book1','book2');
I need to make a query like this: "select * from book where bookname like %book1% or bookname like %book2%"

To make this query in laravel 5 there is an option :

$name = DB::Table('bookinfo')
          ->select('*')
          ->wherein('bookname',$book)
          ->get();

but it use = operator i need to use like operator



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire