UPDATE files
       SET <column> = <predefined value>
       WHERE <column> IS NULL;

UPDATE files
       SET <column> = <predefined value>
       WHERE <column> = '';

UPDATE files
       SET <column> = <predefined value>
       WHERE trim(<column>) = '';