title: SQL find elements is in JSON array column
body: <p>Hello i have a column table who contains json array with tags in it, I try to find a way to select result who contain some of values in it :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>tags</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>[&quot;test01&quot;]</td>
  </tr>
  <tr>
  <td>2</td>
  <td>[&quot;test02&quot;,&quot;test03&quot;]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I try to used <code>JSON_QUERY</code> AND <code>JSON_VALUE()</code>:</p>
  <pre><code>SELECT *
  FROM table_tags  
  WHERE JSON_QUERY(tags,'$') IN ('test01', 'test02')
  </code></pre>
  <p>return nothing</p>
  <p>but with json_value on the first array element [0]</p>
  <pre><code>SELECT *
  FROM table_tags  
  WHERE JSON_VALUE(tags,'$[0]') IN ('test01', 'test02')
  </code></pre>
  <p>it return the first one with test01</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>tags</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>[&quot;test01&quot;]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>i need to find a way to iterate through json_value tags to find all tags in ('test01', 'test02')</p>