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