title: Extract a key from list of key,values pairs in json field mysql
body: <p>I have a data in the following format: </p>
  
  <pre><code>"article_body" : [
          {
              "article_desc" : "THURSDAY, Sept. 1, 2016 (HealthDay News) -- Dapagliflozin improves insulin sensitivity and increases lipid oxidation and plasma ketone concentration in patients with type 2 diabetes mellitus (T2DM), according to a study published online Aug. 25 in Diabetes Care. \n\n Giuseppe Daniele",
              "links" : [{
                      "link_name" : "Full Text (subscription or payment may be required)"}
              ]}
      ],
  </code></pre>
  
  <p>I want to extract the key </p>
  
  <pre><code>article_desc
  </code></pre>
  
  <p>from <code>article_body</code>. </p>
  
  <p>My Snippet of code in Mysql: </p>
  
  <pre><code>SELECT 
  
      JSON_EXTRACT(full_article_json, '$.article_body."article_desc"') AS description,
  FROM
      wc_article_full_data;
  </code></pre>
  
  <p><strong>I'm getting null data, how to parse such data?</strong></p>