Use MySql to decode json data inside a column
<p>I am integrating payment gateway and saving its success or failure response to MySql column.</p>

<p>The data looks like :</p>

<pre><code>{"PG_TYPE":"ABCDE","addedon":"2016-10-21 21:44:17","address1":"","address2":"","amount":"54400.00","bank_ref_num":"623911311289","bankcode":"CC"}
</code></pre>

<p>The data is saving inside column </p>

<blockquote>
  <p>success_response</p>
</blockquote>

<p>Ho do I Suppose to get PG_TYPE from this column using MySQL query?</p>

<p>P.S. - I am using MySQL version 5.5.52</p>