Help for this page

Select Code to Download


  1. 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);