my $sth = $dbh->query($query);
@ip = $sth->fetchcol(1);