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);

1	UPDATE Tablename SET Username = Concat('0', Username);