$dbh->do(q(UPDATE table_name SET `fieldname`=REPLACE(`fieldname`,'‘','''')));