MySQL remove duplicate based on columns
Posted on 2011-10-13
I have a table with multiple duplicate records. Each has a column called f95 that can have either BEAR, FMFL or NAPLES as the data.
How do I craft a query to compare the following fields:
STREET_NUMBER, STREET_NAME, STREET_TYPE, STREET_DIRECTION, UNIT_NUMBER, CITY, ZIP_CODE
and then remove the records based on if the value is FMFL I always keep and remove the others, if not FMFL then keep NAPLES and remove other duplicates
Please show me the correct SQL query to do this.