mysql动态修改列内容

UPDATE test.MyT SET mark1 = (CASE WHEN content LIKE '%ce%' THEN 'c' ELSE NULL END),
mark2 = (CASE WHEN content LIKE '%d9999%' THEN 'd' ELSE mark2 END)