I am creating an api to search users. I am doing this in Eloquent, and I am wondering if there is any way to create a query with Eloquent like this:
SELECT * FROM users WHERE CONCAT('first_name', ' ', 'last_name') LIKE '%searchstring%' OR email LIKE '%searchstring%';
Is there a way to do this with the Eloquent query builder?
What I would like to do is essentially this:
$users = User::where('CONCAT(first_name, " ",last_name)', 'LIKE', '%searchstring%')->orWhere('email','LIKE','%searchstring%')->orderBy($ob, $dir)->paginate($perPage);
This results in Column not found: 1054 Unknown column 'CONCAT(first_name," ",last_name)' in 'where clause'
我正在为搜索用户创建一个api。 我在Eloquent中这样做，我想知道是否有任何方法可以像这样使用Eloquent创建查询：
SELECT * FROM users WHERE CONCAT（'first_name'， ''，'last_name'）LIKE'％searchstring％'或发送电子邮件LIKE'％searchstring％';
有没有办法用Eloquent查询执行此操作 构建器？
我想要做的基本上是这样的：
$ users = User :: where（'CONCAT（first_name， “”，last_name）'，'LIKE'，'％searchstring％'） - ＆gt; orWhere（'email'，'LIKE'，'％searchstring％'） - ＆gt; orderBy（$ ob，$ dir） - ＆gt; paginate（$ perPage）;
这导致找不到列：1054未知列'CONCAT（first_name，“”，last_name）'' 子句'
I was able to find the answer to this question, and the solution was to use the DB::raw method around the column name.
The working solution looks like this:
微信扫一扫$users = User::where(DB::raw('CONCAT(first_name, " ",last_name)'), 'LIKE', '%searchstring%')->orWhere('email','LIKE','%searchstring%')->orderBy($ob, $dir)->paginate($perPage);