title: One product in many categories - PHP MySQL
body: <p>I have a table <code>products</code> (id, barcode, catid, name, description, ...) and I've been asked to make it possible that some products can be assigned to more than one categories.
  The most obvious solution would be to change catid from INT to VARCHAR with delimited values ie 1,2,5 where 1,2 &amp; 5 are the various categories.</p>
  
  <p>Which SQL statement will do the job for me now? I have find_in_set in mind but I think it does the opposite.</p>