mysql replace

[Marcus]

Hi

I have a large database with text strings.

What is the quickest way to replace each ['] with a ['] throughout
the database fields while leaving everything else intact?

ex

.... I'm a monkey ...

becomes

.... I'm a monkey ...

etc

Thanks!

[Wouter]

<snip>What is the quickest way to replace each ['] with a [']</snip>
<off topic>
Maybe you also want to look at this place:
http://www.djwice.com/hulpjes/SpecialCharacters.html

For other characters you want to replace
</off topic>

Sorry, can't help you with the MySQL thing, I also don't know what the
fastest way is to replace all.

Ciao,
Wouter

[Bill Karwin]

Marcus wrote:

What is the quickest way to replace each ['] with a ['] throughout
the database fields while leaving everything else intact?

I'd try this:

UPDATE myTable SET
textField1 = REPLACE(textField1, '\'', '''),
textField2 = REPLACE(textField2, '\'', '''),
textField3 = REPLACE(textField3, '\'', ''');

You probably have to repeat this for every table that contains text fields.

See http://dev.mysql.com/doc/mysql/en/String_functions.html for more
info on REPLACE() and many other string functions built into MySQL.

MySQL has a pretty good set of builtin functions, and familiarizing
yourself with them is a worthwhile thing to do if you use MySQL regularly.

Regards,
Bill K.