I need to concat all columns in a string of a row. Something like this can be possible?
SELECT CONCAT_WS(';', *) FROM db.table
Table:
|col1 |col2 |col3 |
-------------------------
|val11 |val12 |val13 |
|val21 |val22 |val23 |
Result:
val11;val12;val13
val21;val22;val23
Thanks.