Delete duplicate rows with prefix

Discussion in 'MySQL' started by adbox, Nov 10, 2009.

  1. #1
    Hey guys. I'm trying to delete all duplicate rows with a prefix in column "name"
    as "prefix_".

    Anyone know the quick solution?

    adbox
     
    adbox, Nov 10, 2009 IP
  2. adbox

    adbox Well-Known Member

    Messages:
    906
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    155
    Digital Goods:
    1
    #2
    This accomplished what I was out for

     
    adbox, Nov 11, 2009 IP