title: MySQL: How to select a column by number?
body: <p>I'm writing a program, and I have the need to <code>SELECT</code> column names by number, rather than by name.</p>
  
  <p>That is, say the attributes to my table are:</p>
  
  <pre><code>SSN, FirstName, LastName, MiddleName, Address, City, State, Zip
  </code></pre>
  
  <p>How could I select the data just from columns 0 (SSN), 1 (FirstName), 2(LastName), 6 (State)</p>
  
  <p>Is there a way to do this without delving into <code>information schema</code>? </p>