title: Return first unique value in a column with MySQL once
body: <p>I have the following table named stuff:</p>
  
  <pre><code>Serial  Color
  1       Red 
  2       Red
  3       Green
  4       Blue
  5       Green
  6       Green
  7       Orange
  </code></pre>
  
  <p>I run  a simple select query:</p>
  
  <pre><code>SELECT * FROM stuff ORDER BY Serial
  </code></pre>
  
  <p>This simply returns all entries ordered by the Serial. But what I actually need, is for the query to only return the first unique occurrence of each Color while maintaining the same order.</p>
  
  <p>The result set I need returned:</p>
  
  <pre><code>1       Red 
  3       Green
  4       Blue
  7       Orange
  </code></pre>