CODEWITHSUNDEEP
laraveleloquent
Alex
Alex

Reputation: 3855

Eloquent WHERE LIKE clause with multiple columns

I'm implementing a search bar that can search customers by first name, last name, or both. So, for example, Mike Hizer would be matched by Mike, Hizer, zer, Mike Hizer, etc. Here's what I came up with:

Customer::where(
    DB::raw('concat(first_name," ",last_name)'), 'like', "%{$request->search}%"
)->get()

It works. But is there a more Eloquent approach to combine these two columns (first_name and last_name) without resorting to the DB facade? Would something like

->where(['first_name','last_name'], 'like', "%{$request->search}%")

be possible to achieve?

Upvotes: 3

Views: 3821

Answers (2)

Rwd
Rwd

Reputation: 35180

If you don't want to use the DB facade you could use the whereRaw method:

Customer::whereRaw('concat(first_name," ",last_name) like ?', "%{$request->search}%")->get();

Hope this helps!

Upvotes: 6

Rid Islam
Rid Islam

Reputation: 142

$query = User::where('id', '=', '2');

$query->where('first_name', 'LIKE', "%$search%");
$query->or_where('last_name', 'LIKE', "%$search%");
$users = $query->get();

Try this way..

Upvotes: -1

Related Questions