$sth->prepare( 'SELECT ' . join( ',', @fields ) . ' FROM database ETC ETC ETC' );

##</code><code>##

%rowhash{ @fields } = $sth->fetchrow_array();