There is a table:

enter image description here

How does one query in strings, where thursday replace the value with friday, and in the strings friday value with thurdsday?

    1 answer 1

    With the help of cases:

    UPDATE TableName SET day = CASE WHEN day = 'friday' THEN 'thursday' WHEN day = 'thursday' THEN 'friday' END WHERE day IN ('friday','thursday')