Are there StringCollections in MySQL?

I was needing a StringCollection field in my database but I don't know if MySQL has a开发者_C百科nything of the sort, does it?

String collections are usually implemented as a 1-to-many relation with a foreign key. For example, to add a string collection for rows in Table1, you'd set up Table2 like:

Table1: id, name, ...
Table2: Table1Id foreign key references Table1(id), strValue, ...

Example values where Table1 contains football teams, with a string collection of players:

Table1: 1, "Manchester United"
        2, "Liverpool"

Table2: 1, "Bobby Charlton"
        1, "Wayne Rooney" 
        2, "Steven Gerrard"
        2, "Michael Owen"

There is the mysql SET type.