MySQL CONCAT_WS() Function ❮ MySQL Functions Example Add several expressions together, and add a "-" separator between them: SELECT CONCAT_WS( "-" , "SQL" , "Tutorial" , "is" , "fun!" ) AS ConcatenatedString; Try it Yourself » Definition and Usage The CONCAT_WS() function adds two or more expressions together with a separator. Note: Also look at the CONCAT() function. Syntax CONCAT_WS( separator , expression1 , expression2 , expression3 ,...) Resource: https://www.w3schools.com/sql/func_mysql_concat_ws.asp