title: how do i find all duplicate entries in mysql when its two columns?
body: <p>i have a table <code>eng-jap</code> which is essentially just a translation so having an english and a japanese column. a script i made somehow cause every insert to have a clone and thus 1000s of duplicate entries in this table, for example:</p>
  
  <p>duplicate example A</p>
  
  <pre><code>eng                        jap
  "mother washes every day"  "母は毎日洗濯する"
  "mother washes every day"  "母は毎日洗濯する"
  </code></pre>
  
  <p>if it were just one column i could use the query:</p>
  
  <pre><code>SELECT eng, COUNT(*) c FROM `eng-jap` GROUP BY eng HAVING c &gt; 1
  </code></pre>
  
  <p>but since the table can legitimately have a duplicates in eng or jap, as long as its not in both. for example:</p>
  
  <p>duplicate example B</p>
  
  <pre><code>eng                        jap
  "mother washes every day"  "母は毎日洗濯する"
  "every day mother washes"  "母は毎日洗濯する"
  </code></pre>
  
  <p>this is to allow one sentence to have more than one translation. so i need to alter the query to find duplicates as a combination of both columns i guess you could say.</p>
  
  <p>once again to be clear. example B is fine, i want to select all duplicates like example A so i can make a scrip to remove one of all of the duplicates. please and Thank you!</p>