my ($col1,$col2, $col3) = $dbh->selectrow_array("SELECT col1,col2,col3 FROM database where whatever='something' limit 1");