my $query = "SELECT somedata from table WHERE id IN ("
    . join(",", map { $dbh->quote($_) } @ids_to_match )
    .")";

my $sth = $dbh->prepare($query);

$sth->execute();