title: sql - how to split fullname into first and last name
body: <p>If I have a table with a column that contains fullnames such as :</p>
  
  <pre><code>fullname
  ------------
  Joe Bloggs
  Peter Smith
  Mary Jones and Liz Stone
  </code></pre>
  
  <p>How can I retried the first and last name from each of the entries in the full name column  using SQL. I'm not worried about the second name in the 3rd entry in my  example i.e. Liz Stone.</p>
  
  <p>So basically to retrieve</p>
  
  <pre><code>Firstname
  ---------
  Joe
  Peter
  Mary
  
  Lastname  
  --------
  Bloggs 
  Smith
  Jones
  </code></pre>