title: Read MySQL JSON column array as rows
body: <p>I have a table </p>
  
  <pre><code>X
  
   - id
   - name (eg: 'testing')
   - array_column_name (eg: ["value1","value2"])
  </code></pre>
  
  <p>I want a query that will return the following output.</p>
  
  <pre><code>_____________________
  | column1 | column2 |
  | testing | value1  |
  | testing | value2  |
  |_________|_________|
  </code></pre>
  
  <p>Essentially what I need is to convert the array to rows.</p>
  
  <p>I tried using </p>
  
  <pre><code>SELECT name, JSON_EXTRACT(@'array_column_name', '*') FROM X;
  </code></pre>
  
  <p>But I am not sure what to put as the second parameter of the <code>JSON_EXTRACT</code> since my columns contain a plain array instead array of objects.</p>