How to implement a tagging system on a website?

Question

MySQL

I want to add tags to it when creating news on the site. The user who has registered selects the tags that are of interest to him. When news is added and the tags that are set for the news are found in the user's favorites, display the news to him.
How to correctly build mysql tables and make a search query by tags?

Answer 1

Here's the structure I'm using.
post
id | title
tag
id | title
post_tag , where the link is the PK
post_id | tag_id You
can insert tags through Select2