title: MySQL: Select DISTINCT / UNIQUE, but return all columns?
body: <pre><code>SELECT DISTINCT field1, field2, field3, ......
  FROM table;
  </code></pre>
  <p>I am trying to accomplish the following SQL statement, but I want it to return <strong>all columns</strong>.<br />
  Is this possible?</p>
  <p>Something like this:</p>
  <pre><code>SELECT DISTINCT field1, * 
  FROM table;
  </code></pre>