<div>
<div class="content wysiwyg-content">
I have a table that I know has duplicate records. &nbsp;The columns are named:STREET_NUMBER, STREET_NAME, STREET_TYPE, STREET_DIRECTION, UNIT_NUMBER<br />
<br />
There is also a column called MLS_ID that makes this query difficult.<br />
<br />
What is the proper SQL syntax to compare the address columns and display records where the MLS_ID do NOT match but the other columns DO match.<br />
<br />

</div>
</div>


I have a table that I know has duplicate records.  The columns are named:STREET_NUMBER, STREET_NAME, STREET_TYPE, STREET_DIRECTION, UNIT_NUMBER

There is also a column called MLS_ID that makes this query difficult.

What is the proper SQL syntax to compare the address columns and display records where the MLS_ID do NOT match but the other columns DO match.



Complicated Duplicate Records MySQL Query

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.