my $values = join ",", @values; # This is 1 to N values my $sql = <prepare_cached($sql) || die; $sth->execute($values) || die; while ($sth->fetch) { # Do stuff } $sth->finish || die;