title: MySQL select columns by number .e.g. first 3 columns of table x
body: <p>I am trying to avoid using <code>SELECT ALL</code> <code>*</code> but i dont want to specify names instead i want to specify column number in select clause e.g. </p>
  
  <pre><code>SELECT column(1,3,8) FROM my_table
  </code></pre>
  
  <p>Is there working way to do this with one query? </p>
  
  <p>Right now only way i see is run <code>SHOW FULL COLUMNS FROM my_table</code> but then how i make this into one query?</p>