Can you spot if one of more fields have the same data?
Posted: Mon Mar 10, 2014 4:32 am
We have an issue where one or more fields of the database has the same data in it - ie same product stock codes.
We use this to show tickboxes on screen to select "additional accessories".
Trouble is, for whatever reason we have "mini ***" and then "small ***", which are actually the same product.
I'm not bothered about disabling one to be seen, but moreso creating a simple page that shows those products where there are duplicates.
Such as: "SELECT code1, code2, code3, code4 where <any of them> = <any of them>".
I'm trying to find it in a Google search, but not having luck, as most of these duplicate queries are to see if more than one row has the same entry.
ie. http://stackoverflow.com/questions/9239 ... e-in-mysql
We use this to show tickboxes on screen to select "additional accessories".
Trouble is, for whatever reason we have "mini ***" and then "small ***", which are actually the same product.
I'm not bothered about disabling one to be seen, but moreso creating a simple page that shows those products where there are duplicates.
Such as: "SELECT code1, code2, code3, code4 where <any of them> = <any of them>".
I'm trying to find it in a Google search, but not having luck, as most of these duplicate queries are to see if more than one row has the same entry.
ie. http://stackoverflow.com/questions/9239 ... e-in-mysql