Forums / Cotonti / Support / How to delete tags?

First, delete all the unwanted tag references the way you normally would (through the site). Then you can try this query in phpMyAdmin:

DELETE FROM `cot_tags` WHERE `tag` NOT IN (SELECT `tag` FROM `cot_tag_references`);

This will remove any 'orphan' entries in the cot_tags table which don't have a record in cot_tag_references, so they won't show up in tag autocomplete anymore.