Just do: ~~~~ UPDATE t SET c3=c4, c4=c3; ~~~~ The replacement values are computed before any replace occurs, so it is safe to swap values this way.
Just do: ~~~~ UPDATE t SET c3=c4, c4=c3; ~~~~ The replacement values are computed before any replace occurs, so it is safe to swap values this way.