title: Nested column value retreiving
body: <p>Need to get the subset array from the multi dimensional array as filed.The table name is items and having a column named extrafield that column contains multidimensional array.</p>
  
  <p>select extra_fields,'$.*' FROM <code>ij4n1_k2_items</code> where '$.extra_fields' LIKE '"id":"22"';</p>
  
  <p>[{"id":"1","value":"Mumbai"},{"id":"2","value":"USA"},{"id":"15","value":""},{"id":"3","value":""},{"id":"4","value":"<p>Candid photography&nbsp;&lt;/p>\r\n<p>Cinematography&nbsp;&lt;/p>\r\n<p>Pre wedding photography&lt;/p>"},{"id":"22","value":["3836","4114","4270","4961","4217","4224"]},{"id":"6","value":"https://www.weddingsutra.com/images/badge_2.png"},{"id":"7","value":"/images/vendors-img/award_img_3.jpg"},{"id":"8","value":"+91-9769090690 (Ashwin)"},{"id":"9","value":["","","new"]},{"id":"10","value":"shadesphotography@yahoo.com"},{"id":"11","value":"https://www.facebook.com/Shadesphotography"},{"id":"12","value":"https://www.instagram.com/shadesphotographyindia/"},{"id":"13","value":"https://www.pinterest.com/AshwinJhalak/"},{"id":"14","value":""},{"id":"17","value":""},{"id":"18","value":""},{"id":"19","value":""},{"id":"20","value":""},{"id":"21","value":""},{"id":"23","value":""},{"id":"24","value":""},{"id":"25","value":""},{"id":"26","value":""},{"id":"27","value":""},{"id":"28","value":""},{"id":"29","value":""}]</p>
  
  <p>need to retreive
  {"id":"22","value":["3836","4114","4270","4961","4217","4224"]}</p>