title: Search Single Dimensional JSON array in SQL Query (["1", "2", ...])
body: <p>I'm using <code>mysqlnd 5.0.10</code> and I've been trying to figure to figure out how to do <code>Field_A = Field_B</code> (<code>Field_A</code> being a JSON ARRAY).</p>
  
  <p>Field_A = <code>["436","431","437","443","434"]</code>
  Field_B = <code>436</code></p>
  
  <p>I've tried things such as</p>
  
  <ul>
  <li><code>Field_A LIKE Field_B</code> (which isn't accurate enough)</li>
  <li><code>JSON_TYPE(Field_A) IN (Field_B)</code></li>
  </ul>
  
  <p>The version of <code>mysql</code> does not have <code>JSON_EXTRACT</code>, only other way I can see this working is by <code>regex</code></p>