title: How do I select column(s) by their "numeric" position in a table?
body: <p>I am trying to select columns by their "x" position in the table.</p>
  
  <p>DBI</p>
  
  <pre><code>my $example = $hookup-&gt;prepare(qq{SELECT This,That,Condition,"I also want COLUMN-10" FROM tbl LIMIT ? ?});
  
      ###column_number=10 ordinal_position?? 
      $example-&gt;execute('2','10') or die "Did not execute";
  </code></pre>
  
  <p>Is this possible or do I need to run another single select to just that column?</p>
  
  <p>One problem I encountered was with a col named "Condition". For some reason, when I tried to <code>select Condition</code> the execute would die. I never attempted but, What if the column name was SELECT?</p>
  
  <p>Another note is the table is 75 cols wide and I only need 50 of them. The Col names are pretty verbose so, I would like to just call them by their "position". This would also allow the col names to be changed in the future without having to change the select statement.</p>
  
  <p>I am quite the newbie so please explain any answers down to my level. Thanks for any assistance..</p>