title: MYSQL Find In Set with Array Data
body: <p>I have a Database that looks like this (unfortunately cannot be changed)</p>
  
  <pre><code>patients (table)
  name    |   companies
  -----------------------
  Form 1  |     [8,3]
  Form 2  |     [8]
  </code></pre>
  
  <p>I want to select every form with an assignment of 8 so I tried this:</p>
  
  <p><code>SELECT * FROM patients WHERE FIND_IN_SET(patients, 8)</code></p>
  
  <p>But it's not working, I tried another test in a sample database and if the <code>[</code> and <code>]</code> is removed it works just fine, unfortunately the <code>[</code> and <code>]</code> cannot be removed in the live database (this data is stringified from JSON)</p>