使用子查询更新SQL，该子查询引用MySQL中的相同表

I'm trying to update a column's value in a bunch of rows in a table using UPDATE. The problem is that I need to use a sub-query to derive the value for this column, and it depends on the same table. Here's the query:I'm trying to update a column's value in a bunc