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:
|
1 |
UPDATE Tablename SET Username = Concat('0', Username); |
Scenario: You want to append a string or character at the beginning of a db field. solution:
|
1 |
UPDATE Tablename SET Username = Concat('0', Username); |