codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Concat – find duplicates

    18th October 2013

    MySql

    mysql codehaven category

    1
    2
    3
    4
     
    select CONCAT(client,campaign),id FROM cmdata
    WHERE id IN (SELECT id FROM cmdata GROUP BY campaign HAVING COUNT(*) > 1)
     

    Or also very effective , this will work if both the fields are the same…..(like a concat)

    1
    2
    3
    4
    5
    6
    7
     
    delete from cmdata
    USING cmdata, cmdata as vtable
    WHERE (cmdata.id > vtable.id)
    AND (cmdata.campaign=vtable.campaign)
    AND (cmdata.client=vtable.client)
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN