my $q_field = $dbh->quote_identifier($field_name); my $sth = $dbh->prepare(" UPDATE twsJobs SET $q_field = ? WHERE jobId = ? "); $dbh->execute(..., ...);