title: Delete duplicates from `MySQL` and keep single record
body: <p>I am using the following query to find duplicate records and have verified it runs correctly.  </p>
  
  <pre><code>SELECT MLS_LISTING_ID, STREET_NUMBER, STREET_NAME, UNIT_NUMBER, MLS_ID, SALE_PRICE, ZIP_CODE, TLN_REALTOR_ID, COUNT(mls_id)
  FROM idx_FM_BO_NA
  GROUP BY TLN_REALTOR_ID, STREET_NUMBER, STREET_NAME, UNIT_NUMBER, SALE_PRICE
  HAVING COUNT(distinct MLS_ID) &gt; 1; 
  </code></pre>
  
  <p>How do I alter this query to delete duplicates so that there is only one instance of the record? I don't worried which record(s) get deleted, but I need one of them to stay.</p>