title: MySQL select column name as field
body: <p>I have a mysql table that looks something like this:</p>
  
  <pre><code>id | col_1 | col_2 | col_3
  ---|-------|-------|------
  1  | 2     | 34    | 64
  2  | 6     | 53    | 23
  </code></pre>
  
  <p>I would like to be able to query on the id and get multiple rows, one for each column. E.g:</p>
  
  <pre><code>SELECT column_name as column, column_value as value FROM my_table WHERE id=1;
  </code></pre>
  
  <p>Which would give me:</p>
  
  <pre><code>column | value
  -------|-------
  col_1  | 2
  col_2  | 34
  col_3  | 64
  </code></pre>
  
  <p>What would I need to use to formulate a query like this?</p>
  
  <p>Many thanks</p>