title: How do I extract the second to last occurrence of a string in MySQL?
body: <p>I'm using MySQL 5.5.37.  I have a TEXT column that contains values resembling ...</p>
  
  <pre><code>... "id":"51b21a0710340adf6501db67"}},"created":"2014-08-22T15:42:57.969Z","id":"53f76502f82c7abf3d01fba5"},"uri":"/v1.1/events/53f76502f82c7abf3d01fba5"}
  </code></pre>
  
  <p>What I'm trying to figure out is how to extract the 32-character value immediately after the second to last '"id":' string (without the quotes surrounding the 32 character item).  What is the easiest way to do this in MySQL?</p>