title: Extract Data from Delimited string in mySql
body: <p>I have a string which is an input to mysql Stored procedure. The string contains options for multiple choice questions.</p>
  
  <p><strong>Sample String = "Managed code is the code that is compiled by the JIT compilers.~False^Managed code is the code where resources are Garbage Collected.~False^Managed code is the code that runs on top of Windows.~False^Managed code is the code that is written to target the services of the CLR.~False^"</strong> </p>
  
  <p>Each option has two columns i.e. OptionText and IsCorrect. The columns in same options are separated by <strong>"~"</strong> while the rows are separated by <strong>"^"</strong>. 
  I want to insert each of these options into options table. I am confused as to how do I differentiate between two different delimiters in <strong>MySql stored procedure</strong>.</p>