title: SQL - Parse HTML Data in Column
body: <p>I have a column named "Message". In this column there is a data which is HTML code. I need to parse this HTML in SQL then split it 5 different column "Name" - "Surname" - "Email" - "Telephone" - "Message". Here is the HTML format that I need to parse;</p>
  
  <pre><code>&lt;html&gt;
     &lt;body&gt;
        &lt;br&gt;&lt;br&gt;
        &lt;table&gt;
           &lt;tr&gt;
              &lt;td&gt;NameSurname&lt;/td&gt;
              &lt;td&gt;kaydi peldi sord&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td&gt;Email&lt;/td&gt;
              &lt;td&gt;...@gmail.com&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td&gt;Telephone&lt;/td&gt;
              &lt;td&gt;535...5464&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td colspan=2&gt;Message&lt;/td&gt;
           &lt;/tr&gt;
           &lt;tr&gt;
              &lt;td colspan=2&gt;Benfica-Fenerbahçe&lt;/td&gt;
           &lt;/tr&gt;
        &lt;/table&gt;
     &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>First, split NameSurname to Name and Surname. The rule is split from last space (in this sample, it should "Name : ejder mehmet" , "Surname : sıkık", then insert other columns directly. How can I do that? Thanks for answers!</p>