my @exclude_ids = (88, 99); my $sql = 'SELECT * FROM blog WHERE ID NOT IN (' . join(', ', ('?') x @exclude_ids) . ')'; my $sth = $dbh->prepare($sql); $sth->execute(@exclude_ids);