I've inherited a MySQL db (4MB on disk) that's riddled with
inconsistent storage of character entities from being pasted from
Word.  At very least I hope to convert all quotes "‘" - "”"
to HTML's """ and "'".

I imagine I'll run a big query, save the id's needing edit in a file
than have a script hit all those, pulling text/varchar fields, using
strtr() to make changes and updating.  I suppose I could have the
script just do the 1st 10 in the file, remove those from the file,
then I'd recall the script.  I imagine this might take 10/20 minutes.

Am I missing some internal MySQL feature that would do this?  Hmm,
what about running strtr() on a mysqldump-ed file?  Any advice/links
appreciated.  Please CC me.

Thanks a lot!

[EMAIL PROTECTED] ** http://mrclay.org

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

Reply via email to