select concat_ws("'",last_name,first_name) as combined_column
from employees;

用concat_ws函数，语法是

select concat_ws("",column1,column2) as combined_column

from table_name