我有一张桌子叫tenantdetails
其中包含
Tenant_Id | First_Name | Last_Name | ........
我想找回First_Name
and Last Name
通过 MySQL 的串联功能作为一列。所以我写在我的controller
如下
$tenants = Tenant::orderBy('First_Name')->lists('CONCAT(`First_Name`," ",`Last_Name`)','Tenant_Id');
但结果出现以下错误:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '`," ",`First_Name`)`,
`Id` from `tenantdetails` order by `F' at line 1
(SQL: select `CONCAT(`First_Name`," ",`Last_Name`)`, `Id`
from `tenantdetails` order by `First_Name` asc).
在 Laravel Eloquent 中调用 MySQL 函数时如何避免反引号。我只对 Eloquent 感兴趣(对流畅的查询不感兴趣)。提前致谢。
Update
感谢@Andreyco 帮助我。我们可以使用 Laravel 模型以更优雅的方式实现这一点,如下所示:
In our model
:
public function getTenantFullNameAttribute()
{
return $this->attributes['First_Name'] .' '. $this->attributes['Last_Name'];
}
并在我们的controller
:
$tenants = Tenant::orderBy('First_Name')->get();
$tenants = $tenants->lists('TenantFullName', 'Tenant_Id');