my $sth = $dbh->prepare('UPDATE foo SET bar = ?');
$sth->execute($variable);