UPDATE `tableName` SET `fieldName` =
REPLACE(fieldName,"stringOne","stringTwo")

I use the above code to strip strings from my table, and most of the time
this works well. However, I have several fields with double quotes within,
and I would like to remove all double quotes.

Doing this does not work, and generates an error:

UPDATE `tableName` SET `fieldName` = REPLACE(fieldName,""","")

Can anyone point me in the right direction?

Regards,

Gary.