Select Code to Download

select name, address, phonehome, phonework from addressbook;

select name from addressbook;

$info = {
             name => "fred",
};

my @case;
while( my $info = $sth->fetchrow_hashref) {
      push @case, $info->{name};
}
print "@case\n";      # prints built up @case.

my $names = $dbh->selectcol_arrayref(
               "select name from addressbook where name like ?",
...

my @case = @$names;   # If you'd rather deal with an array
print "@case\n";      # prints out ALL of the names selected.