update tableA set column1='22'
where uid in (
select uid from tableA where column1='33'
)
update tableA set column1='22'
where uid in (
select uid from (
select uid from tableA where column1='33'
) tmp
)
https://www.leftso.com/article/852.html