title: How to select only part of a JSON string
body: <p>I have a field that returns </p>
  
  <pre><code>{"nextPONumber":"3","poReportFooter":"This is the footer text for a purchase order report"}
  </code></pre>
  
  <p>I want to pull just the </p>
  
  <blockquote>
    <p>"This is the footer text for a purchase order report"</p>
  </blockquote>
  
  <pre><code>SELECT
    modulesetting.value AS footer_value
  FROM modulesetting
  WHERE modulesetting.key='purchasing'
  </code></pre>