Update Partial data in a column
Hello Great Forum
I have an e- commerce database (x-cart) that has all the productcodes starting with SKU??????
I would like to change all the items that begin with SKU and replace that with a WH
The digits after the SKU will stay there and all I will be replacing is the SKU with WH
In cpanel with PHPadmin I can do one at a time of course but that does not seem like a great idea when we have SQL. I think I have 600 items in the column that I want to change from SKU to WH.
I know I have to do an update for that column but I cannot figure it out,
What would be really nice is to replace the SKU with WH1001 and increment each item by 1 so the next item I replace would be WH1002, WH1003.
Anyway replacing the SKU with the WH is the key.