for my $elem ( @$mysql ) {
    my $field1 = $elem->{field};
}