如何在Laravel查询生成器中执行TRIM()和CONCAT()? [英] How to perform TRIM() and CONCAT() in Laravel Query Builder?

问题描述

我尝试使用FirstName，middlename，Lastname与RAW结合使用查询生成器，但失败了.我的方式错了吗?谢谢

I tried to take FirstName, middlename, Lastname used the Query Builder in combination with RAW but failed. is my way wrong? Thanks

$student = \DB::table('student')
                        ->select(DB::raw('RTRIM(LTRIM(CONCAT(
                                          COALESCE(FirstName +  ''),
                                        COALESCE(MiddleName +  ''),
                                        COALESCE(Lastname, ''))))
                                        AS Name'))
                        ->get();

推荐答案

$student = DB::table('student')
    ->select(
        DB::raw("TRIM(CONCAT(FirstName,' ',MiddleName,' ',LastName)) AS Name")
    )->get();

TRIM 功能-从字符串中删除开头和结尾的空格示例及其使用方式

CONCAT 功能-使用逗号将多个字符串添加在一起:查看示例及其使用方式

CONCAT Function - Add several strings together using comma: See examples and how to use it

希望会为您提供帮助:)

Hope will help you :)

这篇关于如何在Laravel查询生成器中执行TRIM()和CONCAT()?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！