my $sth = $dbh->prepare( 'UPDATE table_name SET `fieldname` = REPLACE( `fieldname`, ?, ? )' ); $sth->execute( q{‘}, q{'} );