RE: [PHP] massive find/replace on MySQL db

om: Julie Meloni [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 15, 2002 11:12 AM > To: Steve Clay > Cc: PHP-GENERAL > Subject: Re: [PHP] massive find/replace on MySQL db > > SC> I've inherited a MySQL db (4MB on disk) that's riddled with > SC> inconsistent stor

Re[2]: [PHP] massive find/replace on MySQL db

Saturday, June 15, 2002, 11:11:49 AM, Julie wrote: JM> update tablename set fieldwithcrap = replace(fieldwithcrap, JM> 'oldstring', 'newstring'); Julie, lovely solution and shockingly fast. Thanks. Steve -- [EMAIL PROTECTED] ** http://mrclay.org -- PHP General Mailing List (http://www.php.

Re: [PHP] 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> to HTML's """ and "'". For each entity you wanted to replace, you could: update tablename set

[PHP] massive find/replace on MySQL db

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