title: MySQL query finding values in a comma separated string
body: <p>I have a field <code>COLORS (varchar(50))</code> in a my table <code>SHIRTS</code> that contains a comma delimited string such as <code>1,2,5,12,15,</code>. Each number representing the available colors.</p>
  <p>When running the query <code>select * from shirts where colors like '%1%'</code> to get all the red shirts (color=1), I also get the shirts whose color is grey (=12) and orange (=15).</p>
  <p>How should I rewrite the query so that is selects ONLY the color 1 and not all colors containing the number 1?</p>