title: How To extract Value from Json multi dimension Array In MySQL
body: <p>column contain value given below.</p>
  <pre><code>
   [
    {
      &quot;bActive&quot;: false,
      &quot;sSubLocation&quot;: &quot;&quot;,
      &quot;aiSeries&quot;: [],
      &quot;iUser&quot;: &quot;1&quot;
    },
    {
      &quot;bActive&quot;: true,
      &quot;sSubLocation&quot;: &quot;Mytestcase&quot;,
      &quot;aiSeries&quot;: [],
      &quot;iUser&quot;: &quot;1&quot;
    }
  ]
  </code></pre>
  <p>I want to get result as sSubLocation key where it have bActive =true and sSubLocation = &quot;Mytestcase&quot;;</p>