CONCAT_WS()

The CONCAT_WS() function adds two or more strings together with a separator. Syntax is CONCAT_WS(separator, string1, string2, …., string_n)

SELECT CONCAT_WS('-', 'SQL',  'vs', 'Python');

Output:
SQL-vs-Python