title: Removing duplicate field entries in SQL
body: <p>Is there anyway I can erase all the duplicate entries from a certain table (<code>users</code>)? Here is a sample of the type of entries I have. I must say the table <code>users</code> consists of 3 fields, <strong><code>ID</code></strong>, <strong><code>user</code></strong>, and <strong><code>pass</code></strong>.</p>
  
  <pre><code>mysql_query("DELETE FROM users WHERE ???") or die(mysql_error());
  
  randomtest
  randomtest
  randomtest
  nextfile
  baby
  randomtest
  dog
  anothertest
  randomtest
  baby
  nextfile
  dog
  anothertest
  randomtest
  randomtest
  </code></pre>
  
  <p>I want to be able to find the duplicate entries, and then <strong>delete all of the duplicates, and leave one</strong>.<br><br></p>