I have a
table
query
SELECT CONCAT(f_name , " - ", l_name ) as fullname FROM user
l_name
null
f_name
NULL
You can use CONCAT_WS:
SELECT CONCAT_WS(' - ', f_name, l_name) as fullname FROM user
concat will return null if a value is null, concat_ws will just skip null values.