my @id=(1,2,3,4); my $sth = $dbh1->prepare("SELECT name FROM table where id in ?") or die "Couldn't prepare statement: " . $dbh1->errstr; $sth->execute(@id)