July 30, 2012February 13, 2013 on MySQL tagged mysql append, mysql append character MySQL query to append character to each entry Scenario: You want to append a string or character at the beginning of a db field. solution: UPDATE Tablename SET Username = Concat('0', Username);