title: How to insert a query result into a column mysql
body: <p>ok so I do this mysql command:</p>
  
  <pre><code>SELECT CONCAT(SUBSTRING(Familenaam,1,4),SUBSTRING(Voornaam,1,4)) AS `Login` FROM tblusers
  </code></pre>
  
  <p>This gives me the result for johny cowbell -_> johncowb (=loginname) but this is in a query.</p>
  
  <p>I want that result in my table tblusers in the column "Login".
  How do I do this?</p>