I am designing a MySQL 6.0 database for a system like a forum. In this system, users can add keywords to 'tag' their posts and comments. Can this be done?
Yes. You can do what you want with triggers, or with application logic in whatever language you are using for your middle Tier