title: How to find duplicate rows based on multiple fields in MySQL?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1799518/mysql-duplicate-rows-duplicate-detected-using-2-columns">Mysql Duplicate Rows ( Duplicate detected using 2 columns )</a>  </p>
  </blockquote>
  
  
  
  <p>In a MySQL database I have many rows. For example:</p>
  
  <pre><code>id | title   | time  | domain
  32   title1    12:30   domain1.com
  33   title1    12:30   domain2.com
  34   title2    14:20   domain1.com
  35   title3    14:30   domain2.com
  36   title1    12:30   domain55.com
  </code></pre>
  
  <p>How am I able to select rows from a database based on <strong>only</strong> title and <strong>time?</strong> Duplicate domains or ID's are not of concern, only the other two fields.</p>
  
  <p>I want to be able to retrieve rows 32, 33 and 36 because they have identical titles and identical times.</p>
  
  <p>I don't want to have to put in a title or time, I want the query to return all fields where there's a "duplicate" match found on these two fields whether that be only two or 50. That way I can go through and edit or delete some of the duplicates.</p>