MySQL - Concat all colums in a string

178 views Asked by At

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.

0

There are 0 answers