title: Using SELECT DISTINCT in MYSQL
body: <p>Been doing a lot of searching and haven't really found an answer to my MYSQL issue.</p>
  
  <pre><code>SELECT DISTINCT name, type, state, country FROM table
  </code></pre>
  
  <p>Results in 1,795 records</p>
  
  <pre><code>SELECT DISTINCT name FROM table
  </code></pre>
  
  <p>Results in 1,504 records</p>
  
  <p>For each duplicate "name"... "type", "state", "country" aren't matching in each record.  </p>
  
  <p>Trying to figure out how to SELECT the associated row to the DISTINCT name, without checking them for being DISTINCT or not</p>