Results 1 to 3 of 3
Mar 5, 2011, 15:20 #1
- Join Date
- Mar 2011
- 0 Post(s)
- 0 Thread(s)
dublicate posts, how to remove 1 and leave one?
actually i have asked this question in many pleases with no luck
fianlly some one guided me here to seek an advice...please..
i have run the following query in the database
SELECT bad_rows. * FROM post AS bad_rows INNER JOIN ( SELECT threadid, dateline, username, userid, MIN( postid ) AS min_postid FROM post GROUP BY threadid, dateline, userid HAVING count( * ) >1 ) AS good_rows ON good_rows.threadid = bad_rows.threadid AND good_rows.dateline = bad_rows.dateline AND good_rows.userid = bad_rows.userid AND good_rows.min_postid <> bad_rows.postid
i have tried to delete them, with no luck...
any idea how to introduce some changes to the code, or inject another code to delete the duplicate entries (leaving one of them)
in simple example
there is an two records (two rows) which shares different id, but both share exactly the duplicate contents including the columns vlauses (also dublicate) , time of the post (also dublicate) etc.. the only difference is the id only.
any idea please?