title: How to get initials from fullname in MySQL?
body: <p>I have a simple table:</p>
  
  <pre><code>id | fullname
  ---------------------------
   1 | Ivanov Ivan Ivanovich
  ---------------------------
   2 | Petrov Petr Petrovich
  ---------------------------
   3 | Alym kyzy Ainura
  </code></pre>
  
  <p>I need transform them into something like this:</p>
  
  <pre><code>id | name_initials
  --------------------
   1 | Ivanov I. I.
  --------------------
   2 | Petrov P. P.
  --------------------
   3 | Alym k. A.
  </code></pre>
  
  <p>I can easily make it via PHP, but MySQL is about data manipulation. I think, it might (and MUST) be done with DBMS only.</p>
  
  <p>How can it be done via pure SQL?
  Should I write stored function for this, or is there any shorter way?</p>
  
  <p>Regards.</p>