title: Perl selectall_array - retrieve all data from array of array ref
body: <p>I am using <code>DBI</code> <code>selectall_array</code> to fetch all the data out of mysql. My query returns 1 columns for every row. But the <code>selectall_array</code> function returns an array of array ref for each row as listed below</p>
  
  <pre><code>$VAR1 = [
            '1.ptmp'
          ];
  $VAR2 = [
            'e1.ptmp'
          ];
  $VAR3 = [
            's2.ptmp'
          ];
  $VAR4 = [
            'sw1.ptmp'
          ];
  $VAR5 = [
            'w1.ptmp'
          ];
  </code></pre>
  
  <p>What I would like is a way to extract all the domains into a single array (no refs) or is there a DBI function which returns a full array of data without any references? I dont want to loop through all data or do <code>fetchrow_array</code> in a while loop. Looking for a single statement to do it all if possible?</p>
  
  <p>Please see my code below:</p>
  
  <pre><code>my @mysqldata = $dbh-&gt;selectall_array('SELECT `domain` FROM dfs WHERE `id` IN ('.join(',',('?')x(scalar(@params))).')', {}, @params);
  my @minus = array_minus( @all, @mysqldata );
  </code></pre>