or download this
my @array_num = (123, 456, 345, 459, 234);
my $sql = 'SELECT tb.num1, tb.num2 FROM MYTABLE tb WHERE tb.num1 IN ('
+ . join(',', ('?') x @array_num) . ') AND tb.num2=?';
my $select = $dbi->prepare($sql);
$select->execute(@array_num, $n2);