title: How to retrieve values stored in JSON array in MySQL query itself?
body: <p>I have the following table</p>
  
  <pre><code>product_id    product_name    image_path                             misc
  ----------   --------------  ------------                           ------
       1            flex        http://firstpl...      {"course_level_id":19,"group_id":"40067"}
       2           Android      http://firstpl...      {"course_level_id":20,"group_id":"40072"}
  </code></pre>
  
  <p>So how can i retrieve the product_name,image_path &amp; only "group_id" value like "40067" from "misc" column.  </p>
  
  <p>I tried below query but it returning 1/0 in Misc column. </p>
  
  <pre><code>SELECT product_name,image_path,misc REGEXP '(.*\"group_id\":*)' as Misc FROM ref_products where product_id=1
  </code></pre>
  
  <p>Any idea guys how to do it ?</p>