title: Fetch Only The Cheapest Prices?
body: <p>I have a table of products, there can be multiple products with the same name but with different prices, i want to display only the cheapest price of each product.</p>
  
  <p>Example Of Table:</p>
  
  <pre><code>TABLE: Products(name,price)
  ---------------------------
  Banana -- 1,25
  Banana -- 1,10
  Strawberry -- 2,43
  Apple -- 1,11
  Apple -- 4,12
  Apple -- // Some Products Can Have the Price Column Empty!!
  </code></pre>
  
  <p>I want a MySQL query to get this:</p>
  
  <ul>
  <li>Banana From: $1,10</li>
  <li>Strawberry From: $2,43</li>
  <li>Apple From: $1,11</li>
  </ul>
  
  <p>Thanks!</p>