# Send our query my $sth = $dbh->query("SELECT clause here;"); # Iterate through the returned rows my @arr = (); while (@arr = $sth->fetchrow) { do whatever } - now I want to get back to the first row of the record set - how do I do it?