String Functions – Insert

/*
  Insert => INSERT(String, Position, Length, New String)
  text => Field Name
*/

SELECT text, INSERT(text, 3, 2, 'Osama') AS newString FROM `try`;

UPDATE `try` SET text = INSERT(text, 4, 6, 'Serial');

UPDATE `try` SET text = INSERT(text, 6, 4, '#');

UPDATE `try` SET text = INSERT(text, 7, 1, id);