srinath madusanka srinath madusanka - 5 months ago 38
MySQL Question

mysql show select output replacing characters

I have some table with email filed, i want to get group of emails using group concat. no issue there

it give out put like following, , ,

but i want to get result as following, ,

I know this can be done using simple PHP explode but i want to know there is any way
to do that only using MYSQL..............


You could use the mysql replace string function around your group_concat:

 Select ...,replace(group_concat(...), '@','_'),...