title: LOCATE everything *after* nth occurrence in string
body: <p>I have strings which have a JSON-like format, including:</p>
  
  <pre><code>..."id":"500", ..., "id":"600", ...
  </code></pre>
  
  <p>I need to parse the <strong>second</strong> <code>id</code> out of the column. I found lots of answers using <code>substring_index</code>, however, I need to get the string <em>after</em> the 2nd (of potentially n) occurrences and not the string <em>before</em> to parse out the ID.</p>
  
  <p>Is there a nice solution?</p>