title: How to extract a list of items from string in SQL
body: <p>I want to split itemid into a list as I want to use the list as a condition in another query:</p>
  
  <pre class="lang-none prettyprint-override"><code>data
  --------------------------------------------------------------------------------
  [{"shopid":64522541,"itemid":1260324852},{"shopid":31863766,"itemid":1265550228}]
  </code></pre>
  
  <p>I have tried JSON_EXTRACT like this: </p>
  
  <pre><code>SELECT JSON_EXTRACT(data,'$.itemid') from table
  WHERE collection_id = 88888
  </code></pre>
  
  <p>but it's not working. Can you please help a way to extract a list that I can use in the below code: </p>
  
  <pre><code>Select id in table2 
  where id in LIST
  </code></pre>