title: MySQL Calculating the sum of each digit of an Text value
body: <p>How to calculate the sum of each digit of an Text value in MySQL? </p>
  
  <p>for example</p>
  
  <pre><code>SET @Chars = CONCAT('1','2','33'); 
  -- @Chars = '1233' 
  
  -- and result should be 1+2+3+3 = 9. 
  </code></pre>