for my $idx ( 0..@$mysql ) {
    my $field1 = $mysql->[$idx]{field1};
}