I'm trying to delete all rows where a specific column does not contain certain strings.
DELETE * FROM table
WHERE Disease NOT LIKE (Malaria, HIV, E. coli O157);
DELETE FROM TABLE_NAME WHERE Disease not in ('Malaria', 'HIV', 'E. coli 0157');
put your actual name of the table in place of TABLE_NAME in the above statement.