title: mysql compare columns in same table
body: <p>I have a table in a mysql db as</p>
  
  <pre><code>id  fruit   number_eaten   day   
  ----------------------------------
  1  apple        2           1
  2  banana       1           1
  3  orange       3           2
  4  apple        1           2
  5  banana       2           3
  6  peach        1           3
  </code></pre>
  
  <p>I'm trying to figure out how to select such that I can compare how many was eaten per day and place into a spreadsheet so i get</p>
  
  <pre><code>fruit     number_eaten_day_1   number_eaten_day_2    number_eaten_day_3
  ------------------------------------------------------------------------
  apple             2                  1                      0
  banana            1                  0                      2
  orange            0                  3                      0
  peach             0                  0                      1
  </code></pre>