Jamshid Hashimi Software engineer and entrepreneur. Notes on software, products, and the work.

MySQL query to append character to each entry

Jul 30, 2012 · MySQL

Scenario: You want to append a string or character at the beginning of a db field.

solution:

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