How can I take one table and scan through it to see if there are any duplicate entries? I would need to match one description field with another to do it... but how could I go about doing that?
basically:
does this field match any others in the same table?
Not sure what database you are using. In Oracle, I can do the following to show me all the duplicates:
select count(), description from myTable group by description having count() > 1;
mySQL
It should also work in MySql. Only one way to find out.......
well the syntax is different.... how would I do this in mysql?
