title: MySQL getting JSON value
body: <p>In my MySql players table I have a column called <code>achievements</code> and it is a text field which in this particular row has this value:</p>
  
  <pre><code>[  
      {  
          "value":11,
          "globalID":23000000
      },
      {  
          "value":11,
          "globalID":23000001
      },
      {  
          "value":11,
          "globalID":23000002
      },
      ...
      {  
          "value":6044730,
          "globalID":23000065
      }
  ]
  </code></pre>
  
  <p>Near the bottom of the array you can see this object:</p>
  
  <pre><code>{  
      "value":48,
      "globalID":23000062
  },
  </code></pre>
  
  <p>I need to be able to parse the value field and show it as a <code>warhero</code> field. But how can I do this? The globalID will stay the same but the value changes. And because the globalID is after the <code>value</code> value I can't use what was used in this post: <a href="https://stackoverflow.com/a/21596032/4942382">https://stackoverflow.com/a/21596032/4942382</a></p>
  
  <p>What SQL query would I need to run to get that value?</p>
  
  <p>Thanks!</p>