查询重复手机号
SELECT
user_mobile
FROM
`t_user`
GROUP BY
user_mobile
HAVING
COUNT( user_mobile ) > 1;
查询重复的手机号及数量
SELECT
user_mobile,
COUNT(*) AS count
FROM
`t_user`
GROUP BY
user_mobile
HAVING
count > 1;
查询所有重复的手机号的详细信息
SELECT
*
FROM
t_user
WHERE
user_mobile IN (
SELECT
user_mobile
FROM
`t_user`
GROUP BY
user_mobile
HAVING
COUNT( user_mobile ) > 1
);