mysql: replace function

[mikerh9]

I need to make query that adds numbers. The fields are varchar format so I have some value 12121 and some values 121212,121212.

I think I need string replace function that replace comma. What function can do this?

[sfullman]

if I understand right you have some fields with something like this:

1,3,25,1

and you want to get:

30

I think NO WAY can you do that with mysql, bad normalization of data. But with the result from mysql you could do:

while($row=mysql_fetch_array($result)){
$x=$row[silly_field_with_commas];
$a = explode(',',$x);
$total=0;
foreach($a as $v) (trim($v)!==''?$total+=trim($v):'');
//voila maybe..

}