Concatenate two columns into one column in a view in MySQL

Question

I am trying to create a view and would like to display the firstName and lastName columns from a table as one column (User) in a view.

The view is using a left join. What I would like to do is join on userID from tableA with concat of firstName and lastName from tableB.

Is this possible in MySql? I have seen some proposed solutions for SQL Server.

Instead of displaying emailAddress column as per below view, I want to display a concat of firstName and lastName columns.

create or replace view document.Documents
as
select
    d.documentID
    ,cu.emailAddress as createdByUser
from document.Document as d
        left join customer.User as cu
            on cu.userID = d.recCreatedByUserID

Answer 1

Yes, use concat or concat_ws:

CREATE VIEW myview AS  
  SELECT concat_ws(' ', firstName, lastName) as "User" 
  FROM mytable;