What is the best way to store book tags in mySQL?

Question

PHP

I am writing a library website. There was a need to store tags in a MySQL table (books are stored in this table). The structure is: klatz . There was an idea to store the tags for the book in the tags field as JSON, specifically like this:

{
    "tags": [
        // [тут теги]
    ]
}

But the problem is that there should be a search for these tags. Therefore, this option seems unacceptable to me. Tell me, how best to store them (tags)?

Answer 1

in a separate table and another table of tag relationships to books.

Answer 2

You should always start with third normal form.
Any denormalization, etc., is done later and separately, when there is an understanding of the tasks and bottlenecks.