用另一个值替换列中的第一个NULL或''值 - MySQL [关闭]

I'm trying to replace the first NULL or ' ' value in a column with another string value.

I'm 100% sure my syntax is wrong. So far it looks like this:

UPDATE table_name SET NULL=new_value WHERE column='' OR column IS NULL

What am I missing here?

Should be new_value = NULL whereas you had NULL=new_Value. Column name should come first. [Assuming new_value is your column name]

UPDATE table_name SET new_value=NULL WHERE column='' OR column IS NULL
                      ------^ //Order was interchanged

UPDATE table_name SET column='new_value' WHERE column='' OR column IS NULL