Update row with 3 column that one of them have previous value?

There must be more going on that what you’ve shown.

AFAIK you should be able to SET to just about anything regardless if the field already has that value
unless
there is a constraint involved
or
there is a problem with the code doing the query

1 Like