How to fix Unknown column 'CONCAT' in Laravel?

Web Development
1

I am trying to CONCAT two columns in Laravel Eloquent, but I am getting the error Unknown column CONCAT.

User::where('id', '=', '10')
->select(
    "id",
    "CONCAT(first_name, ' ', last_name) as full_name",
    "username",
    "email"
)
->get();

Why Laravel taking CONCAT as a column? And how do i fix it?

2

Inside select, you can’t direct call CONCAT. Either use selectRaw or use DB::raw inside select.

User::where('id', '=', '10')
->select(
    "id",
    DB::raw("CONCAT(first_name, ' ', last_name) as full_name"),
    "username",
    "email"
)
->get();