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';