Quote:
Originally Posted by GrouchyAdmin
update table set foo=replace(foo, 'bad', 'good');
|
give it to grouchy...
"table" = name of table
"foo" = field name
bad = that bad apostrophe
good = good apostrophe
Code:
UPDATE tablename SET fieldname = replace(fieldname, '*funky apostrophe here*', ''');
something like that