title: How to split the name string in mysql?
body: <p>How to split the name string in mysql ?</p>
  
  <p>E.g.:  </p>
  
  <pre><code>name
  -----
  Sachin ramesh tendulkar
  Rahul dravid
  </code></pre>
  
  <p>Split the name like <code>firstname,middlename,lastname</code>:</p>
  
  <pre><code>firstname   middlename    lastname
  ---------  ------------   ------------
  sachin     ramesh         tendulkar
  rahul      dravid
  </code></pre>