MySQL Swap Values(not between fields) -

MySQL Swap Values(not between fields) -

i'd inquire help swapping values within single field. table goes this:

table

field1 field2 x hello y test

basically i'd swap x , y values(x becomes test , y becomes hello). know how swap or move values between fields i'm having difficulty this. sorry lame table illustration.

this job successfully

update rules rule1 bring together rules rule2 on ( rule1.rule_id = 1 , rule2.rule_id = 4 ) set rule1.priority = rule2.priority, rule2.priority = rule1.priority ;

mysql