title: MySQL: Storing item properties
body: <p>I need some advice on what would be the best way to store specific information on a <code>MySQL Database</code>.</p>
  
  <p>I have an array of hundreds of items, each one with a specific property <code>color</code>. There is total of 9 colors available and each item may have any combination of those colors.</p>
  
  <p><strong>Ex:</strong></p>
  
  <pre><code>Item1: "green,blue,orange"
  Item2: "red,grey",
  Item3: "green",
  (...)
  </code></pre>
  
  <p>I'm wondering what would be the best way to store that for maximum performance and acessibility.
  Should I just store the array of colors on a single cell and <code>explode()</code> it when necessary, or what would be a better approach to this ?</p>
  
  <p>I want to do this the best way possible to avoid hassles later so I could use some opinions from rather more experienced people.</p>
  
  <p>Many thanks!</p>