my $placeholders = join ",", (('?') x @values);
my $sth = $dbh->prepare(" SELECT *
                    FROM table
                    WHERE field IN ($placeholders) ") or die $dbh->errstr;
$sth->execute(@values);