title: MySQL : how to split text and number with "-"
body: <p>I would like to rewrite a number of user id which is splited by "-" between text and number. For example:</p>
  
  <ul>
  <li>KT-12345</li>
  <li>BA-98765</li>
  <li>CC-98765</li>
  <li>ITA-87987</li>
  </ul>
  
  <p>From a huge amount of data which is mixed up with text and number. For example:</p>
  
  <ul>
  <li>KT98798</li>
  <li>CC94788</li>
  <li>BB87600</li>
  </ul>
  
  <p>So the question is : I would like to make the user id from the 2nd examples into the first one. How to achieve it in MySQL. Please suggest.</p>