my $NewStrID = "foo"; my $OldStrID = "bar"; my $sth = $dbh->prepare("UPDATE Images SET strID=? WHERE strID=?"); $sth->execute($NewStrID, $OldStrID); # ...