Concat_ws

Instead of eplicitly adding each separator

SELECT CONCAT(first_name, ' ', last_name) FROM person_table;

CONCAT_WS(<separator>, <data>)

SELECT CONCAT_WS(' ', first_name, middle_name, last_name) FROM person_table;