title: how to convert column to row in mysql(column having the same value)
body: <p>I have got below format using join query </p>
  
  <pre><code>status | vacancy | selected
  opening|  10     |   5
  closed |  10     |   2
  </code></pre>
  
  <p>but I want to below format, how to get it using 'mysql' query</p>
  
  <pre><code>status  |  selected
  vacancy |  10
  opening |  5
  closed  |  2
  </code></pre>