update all the fields in table which have empty values (MYSQL)

Question

Is there any way to update all the records in a table if there is atleast one filed which has empty value?

Thanks.

Answer 1

Not without using all the fields in the query. If this is your table:

col0: TEXT NULL,
col1: TEXT NULL,
col2: INT NULL

you can issue:

UPDATE YourTable SET col0='yourValue' WHERE col1 IS NULL or col2 IS NULL