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