title: how to split json string into separate rows in mysql
body: <p>I have a json string feeding into a mysql database from a mobile app/website and need to split it into separate rows in a new table. I currently have something like this contained in a field called oceandata:</p>
  
  <blockquote>
    <p>{\"beaches\":[{\"oceandate\": \"9/22/2014\", \"beach\":\"Doheny\"}, {\"oceandate\": \"9/21/2014\", \"beach\":\"Other\"}, {\"oceandate\": \"9/20/2014\", \"beach\":\"Other\"}]}</p>
  </blockquote>
  
  <p>What I really want it to look like is:</p>
  
  <ul>
  <li><strong>oceandate  beach</strong></li>
  <li>9/20/2014   Other</li>
  <li>9/21/2014 Other</li>
  <li>9/22/2014 Doheny</li>
  </ul>
  
  <p>where <code>oceandate</code> and <code>beach</code> are my field names in the new table.</p>
  
  <p>I've tried using <code>common_schema.extract_json_value</code> but have been unable to split out further into separate rows. </p>
  
  <p>Any help is greatly appreciated. Thanks. </p>