How to append some letters or numbers to already existing data

Question

I would like to append some data to already existing data, something like 720967537 to 255720967537. All the data in my column is in that format. Is there any way I can do that to all of the records that are in my MySQL database?

Answer 1

You can use the CONCAT() function:

select concat(255, 720967537), concat('my ', 'test')

Results:

255720967537, my test

SQL Fiddle with Demo

If you want to UPDATE the values in your table, you could do the following:

update t
set col1 = concat(255, col1)
  , col2 = concat('my ', col2);

See SQL Fiddle with Demo