How to make a many-to-many relation?
Let's say I have a table 'Users' and a table 'Interests'.
Interests have some "predefined" rows, with 'name' field, like:
1 | Cars
2 | Pets
3 | Music
A user may have multiple interests. But I didnt find any many-to-many relations.
On the forum I found that I can create a one-to-many relations both in Users and Interests, but when I try, for example, to create such in Users, it creates an additional field in Interests, which can contain only one user relation. Same for Interests table.
In the end I have Users with 'interests' field and 'Interests.users' field, and Interests with 'users' and 'Users.interests'.
I do not actually understand how it will work and what to do.
Maybe the best way could be some kind of ENUM type, but there is no such.
What can be possible solutions?