title: Inserting substring in string at specific index counting from end. How to in mysql?
body: <p>I have problem with mysql insert().</p>
  
  <p>I have strings of variable length (15-20 chars) in a table, and I need to add 4 characters to every string. The catch is that I need to add them exactly 4 chars before the end of the string.</p>
  
  <p>For example, given input string <code>1234567890-123</code> I need to add 'ABCD' before '-', so that the string becomes <code>1234567890ABCD-123</code>.</p>
  
  <ul>
  <li>I tried with insert() function but it can't do it. </li>
  <li>Is there solution for this or do I need to write an application to do it?</li>
  <li>I use MySQL 4.1.</li>
  </ul>