my $rows = $query->fetchall_arrayref([0]); for my $id (@$rows) { print $id->[0]."\n"; }