use DBI; my $dbh = DBI->connect("DBI:mysql:database=your_db"); my $where = "(id = '" . join ("' OR id = '", @ids) . "')"; my $sth = $dbh->prepare("SELECT * FROM event WHERE $where"); #### while ($ref = $sth->fetchrow_hashref) { &do_stuff_with($ref->{'db_col_u_like'}); }