Mysql – How to select users who have similar info (like a shared phone number)

Issue

Just for an example. How can I query my db to find two users who might be using the same phone number? I’m not inputting a specific number but I want to find all instances phone numbers that are being used more than once in the user table.

Solution

SELECT ... FROM users u1 JOIN users u2 
ON u1.user_id <> u2.user_id AND u1.phone_number = u2.phone_number;

Answered By – Bill Karwin

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0