Re: massive find/replace on MySQL db

SC> I've inherited a MySQL db (4MB on disk) that's riddled with SC> inconsistent storage of character entities from being pasted from SC> Word. At very least I hope to convert all quotes "‘" - SC> "”" SC> to HTML's """ and "'". For each entity you wanted to replace, you could: update tablename set fieldwithcrap = replace(fieldwithcrap, 'oldstring', 'newstring'); Keep an eye on all your escaping and what not. And do a dump before you do all your replacing, just in case something goes awry. If that doesn't work well, then I'd probably dump the data, run it through a string replacing script, and load it all back in. That wouldn't take too long either. - Julie --> Julie Meloni --> julie@thickbook.com --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20