Engine23

Updating mysql table column using another column BUT also appending something to that insert

This is how you would take a column from a table in MySQL, insert it into another column, but also append something to that value ( in this case .jpg )

UPDATE items SET imageName = CONCAT(label, '.jpg') WHERE hasImage = 1;

Share: