title: mysql show column based on value
body: <p>I have an unusual table structure which looks like this:</p>
  
  <pre><code>fruit   january   february   march
  ----------------------------------
  apple   10        9          3
  banana  2         1          1
  grape   8         7          7
  </code></pre>
  
  <p>What type of select given 'apple' as the value of the row in the fruit column will give me the column and the highest number for that column, ie</p>
  
  <p>apple, january, 10</p>