更新所有行中特定列的查询

I'm searching for check a columns value in all the rows and update with a where clause as a condition. My case is as follows:I'm searching for check a columns value in all