http://www.perlmonks.org?node_id=450321


in reply to Re^3: fetchall( )
in thread fetchall( )

with something like this:
my $ref = $sth->fetchall_arrayref(); my $second_name = $ref->[1]->[1];
To iterate over all the results and print them, you could do:
my $ref = $sth->fetchall_arrayref(); foreach my $inner (@$ref){ print join ("\t", @$inner), "\n"; }
-albert