Re: [PHP] massive find/replace on MySQL db From: Julie Meloni (julie <email protected>)
Date: 06/15/02

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 "&#145;" - "&#148;"
SC> to HTML's "&#34;" and "&#39;".

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 <email protected>
--> www.thickbook.com

Find "Sams Teach Yourself MySQL in 24 Hours" at
http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php