title: read json array on mysql query
body: <p>I know about the possiblity of duplicity of question but i don't found anything to help me on my situation about it.</p>
  <p>I have this json on my mysql column:</p>
  <pre><code>[
    {
      &quot;ddi&quot;: &quot;55&quot;,
      &quot;routing_id&quot;: &quot;7&quot;,
      &quot;price&quot;: {
        &quot;mt&quot;: 0.0285,
        &quot;mo&quot;: 0.0285
      }
    },
    {
      &quot;ddi&quot;: &quot;598&quot;,
      &quot;routing_id&quot;: &quot;10&quot;,
      &quot;price&quot;: {
        &quot;mt&quot;: 0.06,
        &quot;mo&quot;: 0.06
      }
    }
  ]
  </code></pre>
  <p>When i do the following query:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT JSON_EXTRACT(my_column,'$[*].ddi') as ddi FROM my_table
  </code></pre>
  <p>I get the result:</p>
  <pre><code>[&quot;55&quot;, &quot;598&quot;]
  </code></pre>
  <p>My question is:
  There is a way to return this data on rows instead a json array?
  Like:</p>
  <pre><code>Ddi
  55
  598
  </code></pre>