title: How would I query nested JSON data values in SQL using json_extract()?
body: <p>Mysql version is 6.7+</p>
  <p>Example of the column I need to get a value from below.</p>
  <p><code>json_extract(goal_templates.template_data, group_concat('$.resources'))</code>
  -&gt;This results in a NULL return for all rows.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>:template_data</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td><code>{&quot;Resolve housing issues&quot;: {&quot;tasks&quot;: [{&quot;name&quot;: &quot;Use Decision Map to explore paths to resolving'' housing issue&quot;, &quot;end_date&quot;: &quot;15 days&quot;, &quot;taskType&quot;: 3, &quot;help_text&quot;: &quot;&quot;, &quot;resources&quot;: [], &quot;start_date&quot;: &quot;today&quot;, &quot;actionOrder&quot;: &quot;1&quot;, &quot;recur_every&quot;: &quot;&quot;, &quot;resource_reference_id&quot;: &quot;&quot;}, {&quot;name&quot;: &quot;Select a local Debt &amp; Credit Counseling Service&quot;, &quot;end_date&quot;: &quot;15 days&quot;, &quot;taskType&quot;: 3, &quot;help_text&quot;: &quot;Add &amp; tag local Credit &amp; Debt Counseling Service (Organization)&quot;, &quot;resources&quot;: [&quot;14579&quot;, &quot;14580&quot;], &quot;start_date&quot;: &quot;today&quot;, &quot;actionOrder&quot;: &quot;2&quot;, &quot;recur_every&quot;: &quot;&quot;, &quot;resource_reference_id&quot;: &quot;14579, 14580&quot;}, {&quot;name&quot;: &quot;[Schedule Credit &amp; Debt Counseling as SGE or RGE]&quot;, &quot;end_date&quot;: &quot;15 days&quot;, &quot;taskType&quot;: 3, &quot;help_text&quot;: &quot;&quot;, &quot;resources&quot;: [], &quot;start_date&quot;: &quot;today&quot;, &quot;actionOrder&quot;: &quot;3&quot;, &quot;recur_every&quot;: &quot;&quot;, &quot;resource_reference_id&quot;: &quot;&quot;}, {&quot;name&quot;: &quot;Rate resource for benefit of those who follow&quot;, &quot;end_date&quot;: &quot;15 days&quot;, &quot;taskType&quot;: 3, &quot;help_text&quot;: &quot;&quot;, &quot;resources&quot;: [], &quot;start_date&quot;: &quot;today&quot;, &quot;actionOrder&quot;: &quot;4&quot;, &quot;recur_every&quot;: &quot;&quot;, &quot;resource_reference_id&quot;: &quot;&quot;}], &quot;sequence_num&quot;: &quot;1&quot;}}</code></td>
  </tr>
  </tbody>
  </table>
  </div>