Remove commas using php from mysql

Question

i have a column name fighters which include some value in mysql such as,

| fighters |

| Rock |

| John Cena, |

| UnderTaker,|

So, I want when i Display it in a browser it should appear like

Rock

John Cena

UnderTaker

I just want to remove commas from database using PHP

Any Help will be appreciated..

do you have instances that a comma exists between words? example John, Cena, — John Woo
– John Woo, Commented Apr 26, 2013 at 7:37

chandresh_cool · Accepted Answer · 2013-04-26 07:36:36Z

3

Give

str_replace(",","",$str);

answered Apr 26, 2013 at 7:36

chandresh_cool

11.9k3 gold badges32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave · Accepted Answer · 2013-04-26 07:38:43Z

2

Use REPLACE() in the SQL query

SELECT REPLACE(fighters, ',', '') FROM  table

Though why you'd want to do this in query rather than stripping it on the php side if beyond me

answered Apr 26, 2013 at 7:38

Dave

3,2882 gold badges25 silver badges40 bronze badges

It doesn't specify anywhere that it has to be done with MySQL

...but there is the mysql tag on the question, so it is certainly appropriate.