Finding Duplicate records

Discussion in 'MySQL' started by cancer10, Feb 26, 2009.

0
  1. #1
    Hi

    I have a table called tbl_members with 5,000 records

    I have 3 colums,

    memberID
    member_name
    email_address

    I want to group all members who have similar email address. The select clause should also include memberID and member_name.

    Can you help me setting up a query for this please?

    Thanx
     
    cancer10, Feb 26, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    use group by mysql function
     
    crivion, Feb 28, 2009 IP
  3. cancer10

    cancer10 Guest

    Messages:
    364
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ok that helped.


    Thanx
     
    cancer10, Feb 28, 2009 IP