title: Split a string into two fields based on multiple words
body: <p>I have the following column in my Table name:STAT
  It would be helpful if someone can assist in writing a mysql script
  I would like to split the strings in to 2 columns. However the split should happen only based on the last word, i.e the Region as can be seen in the example below. 
  There is an exception that IF the region is North America then the split should be done considering the last two words, see below
  The script should add the new column to either my existing table named : STAT or to a new table.</p>
  
  <pre><code>---------------------
  Name   
  ---------------------
  P1 xx ASPAC   
  P1 yy EMEA
  P1 zz uu EMEA 
  P2 oouu_xsh-s EMEA
  P2 xx tt North America  
  
  
  ---------------------
  P2           Region
  ---------------------
  P1 xx          ASPAC   
  P1 yy          EMEA
  P1 zz uu       EMEA 
  P2 oouu_xsh-s  EMEA
  P2 xx tt       North America  
  </code></pre>