title: MySQL FIND_IN_SET With Array String
body: <p>I have a field in a table I am querying that looks similar to this:</p>
  
  <pre><code>Name          Phone          Category_IDS          Category_Labels
  Sample        1111111111     ["1"]                 ["foo", "bar"]
  </code></pre>
  
  <p>I am trying to use the FIND_IN_SET function to find all rows that contain one of the values listed in the comma separated list. Something like this returns nothing:</p>
  
  <pre><code>SELECT * FROM sampletable WHERE FIND_IN_SET('1', category_ids) &lt;&gt; 0
  </code></pre>
  
  <p>It does work if I do this:</p>
  
  <pre><code>SELECT * FROM factual_usplaces WHERE FIND_IN_SET('["1"]', category_ids) &lt;&gt; 0
  </code></pre>
  
  <p>But of course that limits to searches to rows where the category_ids or labels only contains a single value in the comma separated list. So ["1"] would be found but ["1", "2"] would not. </p>
  
  <p>Is there a way to remove the brackets and quotations from the string on the fly in the query?</p>