title: MySQL - Select distinct 2 columns and return all
body: <p>First of all, I'm relatively new to MySQL and I'm confused after searching about <code>SELECT DISTINCT</code></p>
  
  <p>My situation is the following:</p>
  
  <p>I have a MySQL table with several columns and hundreds of rows. Each row represents a different product (shirts). It looks like this (simplified):</p>
  
  <pre><code>unique_id | model | color | slots | (...)
  -----------------------------------
  0943535   |  100  |  10   | ab
  0943546   |  100  |  10   | ab
  0943551   |  100  |  23   | ab
  0943562   |  103  |  10   | fk
  0943567   |  103  |  10   | fk
  0943578   |  103  |  17   | fk
  0943582   |  169  |  09   | dv
  (...)
  </code></pre>
  
  <p>Unique_id represents a unique item number. That value is different for each single row in the database.</p>
  
  <p>2 shirts are equal if both <code>model</code> and <code>color</code> are the same.</p>
  
  <p>Like so, I want to print a list (PHP script) with all the columns of the avaliable items in the database but so that the (visually) identical items (the ones of same <code>model</code> and <code>color</code>) are only displayed once. The output should be something like this:</p>
  
  <pre><code>unique_id | model | color | slots | (...)
  -----------------------------------
  0943535   |  100  |  10   | ab
  0943551   |  100  |  23   | ab
  0943567   |  103  |  10   | fk
  0943578   |  103  |  17   | fk
  0943582   |  169  |  09   | dv
  (...)
  </code></pre>
  
  <p>I was told that this should be done using <code>Select distinct</code> in the sql query.</p>
  
  <p>Again, I want to select all columns, excluding duplicates of same <code>model</code> and<code>color</code>.</p>
  
  <p>Please show me what my MySQL query should look like.</p>
  
  <p>Many Thanks!</p>