子查询更新自己

SELECT name,id from users WHERE id<3;

update users set name = ( SELECT * FROM (SELECT name from users WHERE id=2 ) as t2) WHERE id = 1