title: SQL - get list of different values from column
body: <p>I have table in MySql where I have column type</p>
  
  <p>in this column type are different types</p>
  
  <p>each row in table have type,</p>
  
  <p>how to get list of those values ( not repeating = DISTINCT) ?</p>
  
  <p>example:</p>
  
  <pre><code>id    name    type
  -------------------
  1     apple   fruit
  2     onion   vegetable
  3     banana  fruit
  </code></pre>
  
  <p>List: </p>
  
  <pre><code>fruit
  vegetable
  </code></pre>
  
  <p>Idea:</p>
  
  <pre><code>SELECT `type` FROM `food` WHERE ...
  </code></pre>