Searching blog posts with similar tags in Yii?

Question

MySQL

There is a blog on Yii. Each post has a set of tags and keywords. Stored as tag1, tag2, tag3,… Some tags are found in different word forms, i.e. in different cases, numbers.
How to competently and with the least load for a particular post find similar posts based on the match of the largest number of tags? Preferably, with the ability to set a minimum% of matches.

Answer 1

I would create a copy of the database with changes and translate the tags into a normal many-to-many, and dance from here

Answer 2

It is unlikely that the question is still relevant, but look at github.com/yiiext/taggable-behavior

Answer 3

Try FULLTEXT index.