[Solved] MySQL find duplicates based on another column value
You may try below query – SELECT id, user, value FROM YUOR_TABLE T1 WHERE EXISTS (SELECT 1 FROM YOUR_TABLE T2 WHERE T1.value = T2.value AND T1.user <> T2.user) solved MySQL find duplicates based on another column value