while ( $hash_ref = $sth->fetchrow_hashref )
{
   $value_1 = $hash_ref->{"COLUMN_1"};
   $value_2 = $hash_ref->{"COLUMN_2"};

   # Do something with values
}