multiple rows into one line string with

[Agustian Mochammad]

Hi All,

Could you help me in mysql how to query table with multiple rows and result in one string (with delimeter). Let say I've table
Table A
col1
1
2
3
4
5
6
7
8

the query result from table a is :
result
1,2,3,4,5,6,7,8

Please help me.