update sql with select statement

 

update sql with select statement

 

UPDATE table1

SET     field1 = 'value1'

WHERE   fieldID IN

        (SELECT fieldID

        FROM table1

        WHERE expression

        )