Results 1 to 3 of 3
Oct 7, 2009, 18:26 #1
- Join Date
- Mar 2005
- 0 Post(s)
- 0 Thread(s)
Finding and replacig commas in mysql
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?