如何根据其他列的过滤器更新列？

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

# 创建游标
cursor = conn.cursor()

# 查询数据
query = "SELECT * FROM table_name"
cursor.execute(query)
data = cursor.fetchall()

# 应用过滤器并更新列
for row in data:
    if row[0] == "filter_condition":
        # 更新列
        update_query = "UPDATE table_name SET column_name = 'new_value' WHERE id = %s"
        cursor.execute(update_query, (row[1],))

# 提交更改
conn.commit()

# 关闭连接
cursor.close()
conn.close()