while(my $row = $sth->fetchrow_hashref()){
  # evaluate $row->{column} here or 
  # push any interesting $row to a local @array 
  # (e.g. push @myarray, $row)
}