title: How to check if field contains a specific value in mysql?
body: <p>A table field type string can contain comma separated int values e.g. "1,6,2,13" or "3,9,2" or "1,3"</p>
  
  <p>How can I select all entries which are containing e.g. "3" not getting the "13"?</p>
  
  <p>A <code>select * from table where field like '%3%'</code> will not work in that case.
  Nor <code>like '%,3,%</code></p>
  
  <p>Currently I'm trying all combinations: '3,%' , '%,3' , '%,3,%', but I'm wondering if there's a more easy way.</p>