Return Multiple Rows In A String

[zergziad]

Hi All,

I need help on how to return the rows in one particular field as a string with comma separated in
between those data. For example:

Table A

ID Name IsActive
_______________ _______________ _________

1 Amy 1
2 Anne 0
3 Del 0

How do i return resultset like this :

Amy(Active),Ann e,Del

Can we use Concat function in this case?Really hope anyone can give some idea.

[yasmine]

Hi All,

I need help on how to return the rows in one particular field as a string with comma separated in
between those data. For example:

Table A

ID Name IsActive
_______________ _______________ _________

1 Amy 1
2 Anne 0
3 Del 0

How do i return resultset like this :

Amy(Active),Ann e,Del

Can we use Concat function in this case?Really hope anyone can give some idea.

Hi
You can do this by 2 ways.

1. use implode() function of php.
2. use group_concat() function in mysql.

your problem is already discussed here.
Refer the thread Comma Separated which is in MySQL forum.

Thanx n Regards
Yas...

[zergziad]

Hi
You can do this by 2 ways.

1. use implode() function of php.
2. use group_concat() function in mysql.

your problem is already discussed here.
Refer the thread Comma Separated which is in MySQL forum.

Thanx n Regards
Yas...

Hi Yas, thanx for the idea,my problem solved already. For your information,im using asp.net 2.0 not php and i've used to append character using stringbuilder function provided in asp.net (",)

[mwasif]

GROUP_CONCAT() is a MySQL function.

[ronverdonk]

GROUP_CONCAT() is a MySQL function.

And available only with MySql version 4.1 and above.

Ronald