Learn to delete additional tags in datalife engine Database

[robinton]

for do this go to phpmyadmin seletct your database and then run above query:

DELETE dle_tags.* FROM dle_tags
JOIN (
SELECT tag FROM dle_tags GROUP BY tag HAVING COUNT(tag) = 5
) AS subq USING (tag)


your condition is (tag)=5 in this case 5 mean delete tags that their number of publications is 5