subject:"Re\: \[PHP\] massive find\/replace on MySQL db"

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

2002-06-15 Thread John Holmes

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: [PHP] massive find/replace on MySQL db

2002-06-15 Thread Julie Meloni

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