search

bosnadev / repository

Laravel Repositories is a package for Laravel 5 which is used to abstract the database layer. This makes applications much easier to maintain.
https://bosnadev.com
823 stars 233 forks source link

where concat #52

Closed carlituxman closed 8 years ago

carlituxman commented 8 years ago

Hi, how can I do a findwhere with concat something like

select * from TABLE where concat( name, lastname, email ) like %misearch%

carlituxman commented 8 years ago

I answer me:

$q = $this->model->findWhere([ [DB::raw("CONCAT(name,lastname,lastname2)"), 'LIKE', "%$query%"] ]);