title: How to get values from MySQL(5.6) column if that contains json document as string
body: <p>How to get values from MySQL(5.6) column if that contains JSON document as a string </p>
  
  <p>For example, if we have a table - employee in that we have three columns
  id, name and educations.
  and column educations contains data as a JSON document </p>
  
  <pre><code>{"ug":"bsc","pg":"mca","ssc":"10th"}
  </code></pre>
  
  <p>I need the value of ug and pg from educations column </p>
  
  <p>Can we do that using MySQL(5.6) queries?</p>