title: MySQL - Selecting DISTINCT field with other fields
body: <p>I have a table..</p>
  
  <pre>field_1 | field_2 | field_3 | field_4
  data_1  | data_2  | data_3  | data_4</pre>
  
  <p>all the data withing tablename can potentially repeat.</p>
  
  <p>I want to select unique field_1's so that i dont get any repeats, but I also need the rest of that row of data.</p>
  
  <pre><code>SELECT DISTINCT field_1, field_2, field_3, field_4 FROM tablename;
  </code></pre>
  
  <p>The query above obviously does not work. So my question is how can i do this?</p>
  
  <p><strong>Update</strong></p>
  
  <p>How can I prevent the duplicates from displaying.</p>
  
  <p>so if i have  </p>
  
  <pre>data_1|data_2|data_3|data_4
  data_1|data_2|data_3|data_4
  data_6|data_7|data_8|data_9</pre>
  
  <p>the results will only display</p>
  
  <pre>data_6|data_7|data_8|data_9</pre>