title: Storing list of strings in MySql column
body: <p>I have a <em>users</em> table which contains data for registered users, each row represents a user. One column in particular should contain a list of groups the user is part of, at the moment that column is of TEXT type and I'm storing that list as a string where groups are separated with a semicolon, something like:  </p>
  
  <pre><code>admin;moderators;devteam  
  </code></pre>
  
  <p>And I was wondering: "Is this a good idea?", is there a better/safer way to do this that doesn't require a lot of effort to implement or is this "ok"?<br>
  Here is a pic of the table as of now:
  <a href="https://i.stack.imgur.com/QWKxs.png" rel="noreferrer"><img src="https://i.stack.imgur.com/QWKxs.png" alt="users table"></a></p>