title: Moving the first line of a textarea onto a field with a query
body: <p>I have a table like this:</p>
  <pre><code>create table a ( ta text, f1 char(128), f2 char(128) );
  </code></pre>
  <p>With data:</p>
  <pre><code>insert into a values (&quot;line 1 for first record\nThis is the rest of the body\nLike this&quot;, &quot;&quot;);
  insert into a values (&quot;line 1 for second record\nThis is the rest of the body again\nLike this&quot;, &quot;&quot;);
  </code></pre>
  <p>I need a query that will:</p>
  <ul>
  <li>Delete the first line out of <code>ta</code></li>
  <li>Place that first line into <code>f1</code></li>
  </ul>
  <p>The query would need to change this:</p>
  <pre><code>+-----------------------------------------------------------------------+------+------+
  | ta                                                                    | f1   |f2    |
  +-----------------------------------------------------------------------+------+------+
  |line 1 for first record\nThis is the rest of the body\nLike this       |      |      |
  |line 1 for second record\nThis is the rest of the body again\nLike this|      |      |
  +-----------------------------------------------------------------------+------+------+
  </code></pre>
  <p>Into this:</p>
  <pre><code>+----------------------------------------------+------------------------+------+------+
  | ta                                           | f1                            |f2    |
  +----------------------------------------------+------------------------+------+------+
  |This is the rest of the body\nLike this       |line 1 for first record        |      |
  |This is the rest of the body again\nLike this |line 1 for second record       |      |
  +----------------------------------------------+-------------------------------+------+
  </code></pre>
  <p>I spent way too long trying unsuccessfully. I am just about ready to give up.</p>
  <p>Is there an easy reliable way to do that?</p>
  <p><strong>BONUS QUESTION:</strong>
  Could you extend the answer so that the first line goes to <code>f1</code> and the second line goes to <code>f2</code>?</p>
  <p>So the result would be:</p>
  <pre><code>+------------+------------------------+----------------------------------+
  | ta         |f1                      |f2                                |
  +------------+------------------------+------+------+--------------------+
  |\nLike this |line 1 for first record |This is the rest of the body      |
  |\nLike this |line 1 for second record|This is the rest of the body again|
  +------------+------------------------+----------------------------------+
  </code></pre>