$results->[0]; // Reference to a hash ref of Row_1 my %row_1 = %{$results->[0]}; // Hash of Row 1 $results->[0]{name}; // Name column from Row_1 // to iterate over the record set you might do this: // id, position, name are column names from the table for (@{$results}) { my $id = $_->{id}; my $position = $_->{position}; my $qb_name = $_->{name}; }