prova con

DELETE FROM `messaggi` WHERE file = '';

oppure

DELETE FROM `messaggi` WHERE file = NULL;

bye