database - Use concat with as inside concat funcation in MySQL -

i have 3 columns in table: firstname, lastname , jobtitle. want concat firstname , lastname fullname concat fullname , jobtitle. how can that?

you do:

select concat_ws(' ', firstname, lastname) name, concat_ws(' ', firstname, lastname, jobtitle) nametitle

you cannot re-use column alias in same select, have repeat expression.

edit:

if want 1 column of form, perhaps:

select concat(firstname, ' ', lastname, ', ', jobtitle)

mysql database concatenation alias

Jaimee