I have the following SQL which I have written to update a tables values:
SET S_Type = 'Versus'
Where S_Type = 'REGULAR'
SET S_Type = 'Free'
Where S_Type = 'CASH';
Here , we are using case statement and find result like as where clause :
update tablename set S_Type = (case S_Type when 'REGULAR' then 'Versus' when 'CASH' then 'free' else s_type end)