Copy and Append in MySQL
I have a MySQL database with a productnumber and productimages field. The productnumber field already has data in it eg. prod001, prod002 etc
So I was wondering if anyone knew if there was an easy way to copy the data into the productnumber field but change it so that it was in the format images/productnumber.jpg (images/prod001.jpg images/prod002.jpg) etc.
I'm pretty new to all this database stuff if you cant already tell:)
Edit: Been trying this but it doesn't seem to like it very much :(
update products set `productimages` = 'images/' + `productnumber` + '.jpg';
UPDATE <table> SET `productimages`= CONCAT('images/', `productnumber`, '.jpg')
wow that was quick. Worked a treat, cheers:thumb: