雄辩的WHERE LIKE子句具有多列 [英] Eloquent WHERE LIKE clause with multiple columns

问题描述

我正在实现一个搜索栏，可以按名字，姓氏或两者来搜索客户.因此，例如，Mike Hizer将与Mike，Hizer，zer，Mike Hizer等匹配.这是我想出的:

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()

有效.但是，是否有一种更雄辩的方法来组合这两个列(first_name和last_name)而无需求助于DB Facade?会是

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}%")

有可能实现吗?

推荐答案

如果您不想使用DB外观，则可以使用whereRaw方法:

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();

希望这会有所帮助！

这篇关于雄辩的WHERE LIKE子句具有多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！