title: SQL parsing delimited data in one column out to two other columns
body: <p>I have an existing table in MySQL with data synchronized data that ends up looking something like this:</p>
  
  <pre><code>id      client      notes           id1         id2
  ------- ---------   ------------    ----------  ----------
  1       a           cat dog|3|90
  2       b
  3       c           |80|12
  4       d           dog only
  5       e
  6       f           |34|40
  </code></pre>
  
  <p>I want it to look like this:</p>
  
  <pre><code>id      client      notes           id1         id2
  ------- ---------   ------------    ----------  ----------
  1       a           cat dog|3|90    3           90
  2       b
  3       c           |80|12          80          12  
  4       d           dog only
  5       e
  6       f           |34|40          34          40
  </code></pre>
  
  <p>What is the SQL logic to accomplish this? The delimiter will always be two pipes. That is I want a statement that I can apply to the table in phpMyAdmin to clean up the sync and separate out the id's properly.</p>