my $rows = $sth->fetchall_arrayref; for my $row ( @$rows ) { my @fields = @$row; # do something with @fields... } # or, if the per-field activity is pretty dense: for my $row ( @$rows ) { for my $field ( @$row ) { # do something with $field... } }