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> 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

Find "Sams Teach Yourself MySQL in 24 Hours" at

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to