[SOLVED] newbie question - copying column but adding txt

[remero]

I'm new to mysql but learning, so thanks for any help.

 

I am trying to copy a column on my table but also to add txt to the end of the copied column but cant seem to figure out how ie

 

UPDATE MYTABLE SET IMAGEFILE=USERNAME

 

this copies the column USERNAME to IMAGEFILE but i would like to add the txt .jpg to the end of all the entries in the IMAGEFILE column so they end up USERNAME.jpg, but i cannot seem to find a way to do this without the .jpg replacing the whole column.

[GingerRobot]

Try:

 

UPDATE tbl SET IMAGEFILE = CONCAT(USERNAME,'jpg')

[remero]

Cheers mate worked perfect thx for the help