Update a field value on a MYSQL table by using a conditional subquery. Replace the occurrence of a character with a new one.

updating.sql

-- update any occurrence of a quote character from a string in mysql

update site_user as original 
join (select site_user.id, replace(site_user.email, "\"", "") as new_email from site_user where email like "%\"%") as conditional
on original.id = conditional.id
set original.email = conditional.new_email;

--follow me on twitter: www.twitter.com/anthonyrod4