srinath madusanka srinath madusanka - 1 year ago 83
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..............

Answer Source

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

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


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download