my $name = q(Blah's Blubb " ; "); my $id = 1234567; my $sth = $dbh->prepare("SELECT id from table WHERE id == ? AND name = ?") or die $sth->errstr; my $rv = $sth->execute($id, $name) or die $sth->errstr;