Another workaround could be CONCAT

SELECT
  CONCAT(column1, ':', column2, ':', column3)
FROM table;