I have a huge table of products from a specific vendor with a UPC column. I need to differentiate these products' UPCs from other vendors. The current idea is to prepend all of these UPCs with the letter a
.
UPDATE abc_items SET upc = 'a' + upc
is basically how I imagine doing something like this, but I know it will not work.
Just use the CONCAT function.