What is the best way to make a list in a database?

Question

Database

I need something like this:

That is, so that the record in the database contains a list and when accessing any element of the list, a record is displayed. The values ​​from the second column are equivalent, that is, there are no subject / non-subject values, the search must be specific by words
SELECT * FROM items WHERE note='Предмет'- the output of algebra and biology
For this, you can save a list of values ​​​​in the record parameter or do you need it somehow differently?

Answer 1

You need to read about why bases are called relational , and about their normal forms . You need a many-to-many relationship .