Finding and replacig commas in mysql

[bruin03]

I tried this but it doesn't seem to work.

UPDATE `livesite` SET `guid` = REPLACE(`guid`,',','-');

I then thought it was a simple case of exscaping the comma and tried this, which didnt' work either.

UPDATE `livesite` SET `guid` = REPLACE(`guid`,'\,','-');

How can I replace commas with hyphens or dashmarks in my column?

[r937]

define "doesn't seem to work"

watch, i can make it work just fine --

CREATE TABLE livesite
( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
, guid VARCHAR(99)
);
INSERT INTO livesite (guid) VALUES
 ( 'value.with.no.commas' )
,( 'value,with,commas' )
;
SELECT * FROM livesite
;
UPDATE livesite SET guid = REPLACE(guid,',','-')
;
SELECT * FROM livesite
;

if you run that code, you'll see that it actually ~does~ work

[bruin03]

That's odd. I don't know why, but I couldn't get it to work earlier.
(I'll admit I was using it in a trigger and it said the error occured right before the above t so I thought that was the problem). *shrugs*