title: Split delimited string value into rows
body: <p>Some external data vendor wants to give me a data field - pipe delimited string value, which I find quite difficult to deal with.</p>
  
  <p>Without help from an application programming language, is there a way to transform the string value into rows?</p>
  
  <p>There is a difficulty however, the field has unknown number of delimited elements.</p>
  
  <p>DB engine in question is MySQL.</p>
  
  <p>For example:</p>
  
  <pre><code>Input: Tuple(1, "a|b|c")
  
  Output:
  
  Tuple(1, "a")
  Tuple(1, "b")
  Tuple(1, "c")
  </code></pre>