I'm creating a database for the first time! The goal is to have a database for users. I'm using PHPMyAdmin on my localhost (XAMPP) to set it up.
This is pretty straightforward for things like "username" and "password", but one of the fields would be a list of activities that the user participates in.
So for instance, "Activities: Skiing, Rowing, Swimming" would be what this would look like on their page.
But I am not sure how to set this up on PHPMyAdmin. I can't just create a field called "Activities" of type VARCHAR(255) because I think it would store their interests in one box, which isn't good because I need to have these separatedly sorted for later access (For instance, I'd need to query all the users that have the "Swimming" activity in common).
What approach should I ideally be using?
Thank you!