title: How can I find multiple occurrences of a substring within a string using MySQL Workbench?
body: <p>The query I'm trying to write (using MySQL Workbench) needs to search a text field and return all the occurrences of a "placeholder" substring within the text field.</p>
  
  <p>The text I'm searching is actually a document containing placeholders and I would like to see a list of all the placeholders in it. Each placeholder has a different value, but it is demarcated by special characters(e.g. |^ ... ^|).</p>
  
  <p>The problem I'm having is that I cannot do looping or recursion in Workbench to search through the text field, so I need some other method to search it. All the MySQL functions that I have tried (e.g. locate() ) only return the first occurrence of the substring (or it's position).
  <br/><br/>
  If my text field is:<br/><br/>
  "blah blah blah |^123^| blah blah blah |^456^| blah blah blah |^789^| blah"</p>
  
  <p><br/>
  I would like to see:<br/><br/>
  Placeholder  <br/>
  ---------------- <br/>
  123 <br/>
  456<br/>
  789</p>