What is the best way to organize tags in a database?

Question

MySQL

Task: there are users, tasks these tables can have tags.
You can make 2 tables with tags and tag links.
You can make a view to get the view:
id, name, tags separated by commas.
But is it possible to make a query like:
SELECT * FROM users_with_tags WHERE tags IN ('best', 'new')
to select users with tags?
I would like to make work with tags inside and convenient outside.

Answer 1

so...let's figure it out. Can users have tags too? Or tags only for tasks?
And so there are two options:
- normalize everything, tags in a separate table, link through links. Flexible and a little more difficult.
- store tags in an array for tasks, postgresql does. It's simple, fast, and it will only be difficult to organize an autocomplete and fetch a list of existing tags. In this scenario, the first option is more efficient.

Answer 2

Do through a many-to-many relationship. (table tags and links).
In one of the projects, it was necessary to make quick selections by tags, and it turned out that it was faster to do them through such a connection. (when there is a table of tags and a table of links).
Alternatively, mysql has such a function - find_in_set