在mysql和php中找到重复的条目，然后在下面列出所有条目

Question

I want to get all the entries from mysql table having duplicate mobile_no and email_id, i tried the following query but no luck

SELECT * FROM duplicate WHERE (mobile_no = (SELECT mobile_no FROM duplicate)) ORDER BY id DESC

BUT IT RETUNS 'Subquery returns more than 1 row'

please suggest some query. Column Names: mobile_no, email_id

Answer 1

If you want the whole row, you can do this...

SELECT
  *
FROM
  duplicate
WHERE
  EXISTS (SELECT *
            FROM duplicates   AS lookup
           WHERE lookup.id <> duplicate.id
             AND (  lookup.email_id  = duplicate.email_id
                 OR lookup.mobile_no = duplicate.mobile_no
             )
         )