mysql 对换（替换）两条记录的同一个字段值

1、回访问题上、下排序sql语句

UPDATE
   table_bank  bank
   join  table_bank  visit  on (bank.id = 1 and visit.id = 23) or (bank.id=23 and visit.id =1)
SET
   bank.order_no = visit.order_no,
   visit.order_no = bank.order_no