I have 2 column 1 table and based on TABLE1_vaccinated if that is 'Yes' then change TABLE1_vaccination_status to 'vaccinated'
Solution 1:
Check with this code
CREATE TABLE table1(
Vaccinationstatus VARCHAR(10),
Vaccinated VARCHAR(3)
);
INSERT INTO table1 (Vaccinated)
VALUES('yes');
SELECT * From table1;
UPDATE table1
SET table1.Vaccinationstatus = 'Vaccinated'
WHERE table1.Vaccinated = 'yes'