I know this is a very easy question, but how do I change a certain value in a table?
WHOLESALERID WHOLESALERBUSINESS NAME WHOLESALERADDRESS WHOLESALERCITY WHOLESALERSTATE WHOLESALERCONTACTNO
WOO1 GOT WHOLESALERS 24 LANECOVE RD SYDNEY NSW 0298999099
WOO2 SUIT WHOLESALERS 562 PRINCESS ST CANBERRA ACT 0290009000
Above is my table, I need to change WOO1 to W001, how do I do this?