mysql交换两条记录中的某一个字段的值

mysql交换两条记录中的某一个字段的值

UPDATE 
	tbl_core_member c
JOIN 
	tbl_core_member cc 
ON 
	(c.id = id1 AND cc.id = id2) OR (c.id = id2 AND cc.id = id1)
SET
	c.sort = cc.sort , cc.sort = c.sort