update multiple rows with multiple columns using loop

hi mate,
i have this query statement
UPDATE kai
SET `0522` = CASE WHEN `0522` IS NULL OR '0' THEN '' ELSE '1' END,
`0529` = CASE WHEN `0529` […]

See original post by invalid@example.com (neilfurry)