title: MySQL Search A Comma Delimited String
body: <p>I have a table with a column that contains a list of tags/labels in a comma delimited list.  For example: <code>pending,review,accounting</code>.  </p>
  
  <p>I want to do a SELECT by searching for given tags.  If I do:</p>
  
  <p><code>SELECT * FROM TABLE_records WHERE TAGS LIKE %review%</code></p>
  
  <p>This works just fine.  However, If I do something like:</p>
  
  <p><code>SELECT * FROM TABLE_records WHERE TAGS LIKE %pending,accounting%</code></p>
  
  <p>This yields no results.  Is there a way to accomplish this without having to do a million different LIKE statements?  Essentially if any of the tags specified in the LIKE query matches a tag in the column, I'd like to return the record.</p>
  
  <p>Thank you!</p>