[MySQL]같은 테이블 참조하여 UPDATE

update 
	TABLE A,
    (select
        *
    from
        (
        select
            *
        from	
            TABLE
        // where
            ...
        // order by
            ... ) T
    // group by
        ... ) B
set 
	A.NAME = B.NAME
where 
	A.ID = B.ID