January 27, 2004
MT Extensions: Removing Duplicates Using MySQL 1.0
An essential for your Movable Type toolbox: MT Extensions: Removing Duplicates Using MySQL 1.0
update:
I updated the SQL query so that it better suits my needs:
SELECT DISTINCT CONCAT as ‘SQL’
FROM mt_comment AS t1 JOIN mt_comment AS t2 ON
t1.comment_entry_id = t2.comment_entry_id &&
t1.comment_author = t2.comment_author &&
t1.comment_email = t2.comment_email &&
t1.comment_text = t2.comment_text &&
t1.comment_url = t2.comment_url
WHERE t1.comment_id < t2.comment_id;
Comments
Post a comment