title: MySQL, return only rows where there are duplicates among two columns
body: <p>I have a table in MySQL of contact information ; </p>
  
  <p><strong>first name</strong>, <strong>last name</strong>, <strong>address</strong>, <strong>etc</strong>. </p>
  
  <p>I would like to run a query on this table that will return only rows with <strong>first</strong> and <strong>last name</strong> combinations which appear in the table more than once. </p>
  
  <p>I do not want to group the "duplicates" (which may only be duplicates of the first and last name, but not other information like address or birthdate) -</p>
  
  <p>I want to return all the "duplicate" rows so I can look over the results and determine if they are dupes or not. This seemed like it would be a simple thing to do, but it has not been. </p>
  
  <p>Every solution I can find either groups the dupes and gives me a count only (which is not useful for what I need to do with the results) or doesn't work at all. </p>
  
  <p>Is this kind of logic even possible in a query ? Should I try and do this in Python or something?</p>